How do I count or display unique data in a column?

kbeilers

Posts: n/a

How do I count or display unique data in a column?

I want to display all the unique names in a column, but I can't find a
"unique" command. I also want to be able to count all the unique names in
the column.

Ideas?

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
find rows for unique data in 1 column and different data in other.	Dot Majewski	Excel Discussion (Misc queries)	1	January 21st 05 12:23 AM
Column in CSV file contains "03/04" should not display as 3-Apr -.	The Palewhale	Excel Discussion (Misc queries)	1	December 13th 04 04:31 AM
Count of unique items meeting condition	Tim C	Excel Worksheet Functions	1	November 12th 04 03:03 AM
getting data from 2 excel sheets automatically	pinar	Excel Worksheet Functions	0	November 9th 04 11:47 AM
Count rows based on multiple criteria	Murph	Excel Worksheet Functions	1	October 28th 04 07:13 AM

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

Menu

About Us