Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extract Unique entries in a column
is there a function that would look at a range of cells and extract the
unique entries in the range and diplay them in a new "array" or column. I would like to look at a column several hundered rows long and determine what was entered in the column and how many times it was entered. I know I could review the data and set up a column with the data I saw and do a countif but I am looking for something a little cleaner that isn't dependent on me to see every entry. Thanks Jeff -- Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extract column or row reference | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
set up a column in excel with unique entries | Excel Discussion (Misc queries) | |||
How do I sort a column a unique number? | Excel Worksheet Functions |