Daniel - Sydney

Posts: n/a

Counting item in a column

Hi

I have a spread sheet where there is a column with over 3000 cells,
there are 90 items, some appearing often and some only a few times.
Is there a way I can sort the column by the number of time an item appears,
or to highlight how many time each item appears.

thanks

Daniel

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
match and count words	David	Excel Worksheet Functions	5	July 4th 05 02:24 AM
counting similar items in a column	bj	Excel Discussion (Misc queries)	5	June 6th 05 10:30 PM
counting only specific numbers in column	Alex C	Excel Worksheet Functions	2	May 25th 05 08:32 PM
Counting NUMBERS &/or TEXT from a column to other sheet ?	Trixie	Excel Worksheet Functions	4	March 3rd 05 07:59 PM
How can I sort an entire spreadsheet from a list	prod sorter	Excel Worksheet Functions	4	November 17th 04 03:43 AM

All times are GMT +1. The time now is 11:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us