LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
andy
 
Posts: n/a
Default how can I list items in a column with totals?

how can I list items in a column with totals?

I have a column containing a list of multiple (text) items.

I'd like to have a summary, so that I have a list of the items together with
the totals of how many times the item appeared.

I guess this must be simple, but don't know how to go about it.

Cheers
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Indexing items from a pick list Pank Mehta Excel Discussion (Misc queries) 1 February 3rd 05 09:29 AM
How do I subtract 20% from one column in Excel and place totals i. Full Effect Landscaping Excel Discussion (Misc queries) 2 February 2nd 05 01:42 AM
Comparing/matching totals in a column to totals in a row Nicole L. Excel Worksheet Functions 3 January 27th 05 10:42 PM
How do I find out what items are in one list but not in another l. Michelle Craig Excel Discussion (Misc queries) 2 December 22nd 04 08:32 PM
Insert column entries from a master list RichLorn Excel Worksheet Functions 0 October 28th 04 08:57 PM


All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"