| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter Unique Values
I am filtering a list for unique values using Advanced Filter. Once I filter
the first value shows up in the list twice.... A1 Cat A2 Cat A3 Dog A4 Bird A5 Snake If I reference the first occurence of Cat (A1) in a formula in B1 such as =a1 ="Cat", the formula is changed to EXTRACT = "CAT". What is this and how do I get rid of it. I dont need 2 occurences of CAT Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter for unique values in multiple columns | Excel Discussion (Misc queries) | |||
| Filter for Unique Values not working | Excel Discussion (Misc queries) | |||
| count unique values & filter | Excel Worksheet Functions | |||
| unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
| Unique Value without using FILTER | Excel Worksheet Functions | |||
Threaded Mode
