Cable Forum - Excel question : help please

Cable Forum (https://www.cableforum.uk/board/index.php)

- General IT Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=19)

- - Excel question : help please (https://www.cableforum.uk/board/showthread.php?t=33706774)

Mike	29-08-2018 08:16

Excel question : help please

1 Attachment(s)

Hi all

Would appreciate any help with this please, I would like to try and get data (text) on the same line rather than as a sub group under a heading

Ie List

City Street Cost
London High Street 100
London Long Road 200
London High Street 50

To show...

London High Street 150
London Long Road 200
Total 350

Also attach the spreadsheet which show what I currently have and what I would like.

Many thanks for your help and time

Regards

Mike

spanna

29-08-2018 12:17

Re: Excel question : help please

1 Attachment(s)

I'm no expert but does this help?

Mike	29-08-2018 14:39

Re: Excel question : help please

Quote:

Originally Posted by spanna (Post 35961638)

I'm no expert but does this help?

Yes it does thanks....got it...

It was just my spreadsheet displayed different options

Thanks again

Mike

Lutherf

29-08-2018 14:46

Re: Excel question : help please

You are looking for a function that Access is MUCH better suited for.

All times are GMT +1. The time now is 13:03.