Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count unique entries
I am trying to count the number of unique entries in a column of data but
based on data in other columns. I need this to be automated versus filtering the data and cut/pasting, etc. For example, if I want to know how many unique entries in Column C are "2005, FEB" the answer I'm looking for is: 1 COL A COL B COL C 2006 JAN 3 2006 FEB 4 2005 FEB 5 2005 FEB 5 2005 JAN 5 Can one of your smart folks help me out? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
Count unique entries | Excel Worksheet Functions | |||
Count of unique entries | Excel Discussion (Misc queries) | |||
how to count unique entries with multiple condition | Excel Worksheet Functions | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions |