Home |
Search |
Today's Posts |
#1
|
|||
|
|||
UNIQUE
I have a sheet with 47000 rows and 6 columns. I want to
filter it to unique records based on the contents of the values of Colmun C. How do I do this, I have indicated Filter List in place, List Range $A$1:$F$47000, Criteria range $C$ and ticked Unique records only. It still does not show only unique records. Thanks for help |
#2
|
|||
|
|||
Hi
try Ron's addin to make this a little bit easier: http://www.rondebruin.nl/easyfilter.htm -- Regards Frank Kabel Frankfurt, Germany "GERRYM" schrieb im Newsbeitrag ... I have a sheet with 47000 rows and 6 columns. I want to filter it to unique records based on the contents of the values of Colmun C. How do I do this, I have indicated Filter List in place, List Range $A$1:$F$47000, Criteria range $C$ and ticked Unique records only. It still does not show only unique records. Thanks for help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
Unique Words | Excel Discussion (Misc queries) | |||
How do I get unique values from 2 columns? | Excel Discussion (Misc queries) | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
generating Unique ID numbers for students | Excel Worksheet Functions |