In deadline trouble .. need help with Excel 2000 unique rows .. I highlighted entire table, selected Toolbar/Data/Advanced Filter, highlighted entire table for 'List range', highlighted entire table for 'Criteria range' .. checked 'Unique Records Only' option, 'ok'.. and it only removed 90% of the duplicates.... Am I incorrect in setting 'Criteria range'? In my case EVERY field IS the criteria.. Please help..
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
deadline trouble.. need help with Excel 2000 unique rows
- Thread starter RDC
- Start date
Post a small sample of your data and give the ranges
Regards
Ken................
----------------------------------------------------------------------------
![[peace]](/data/assets/smilies/peace.gif "[peace] [peace]")
It's easier to beg forgiveness than ask permission![[2thumbsup]](/data/assets/smilies/2thumbsup.gif "[2thumbsup] [2thumbsup]")
----------------------------------------------------------------------------
Regards
Ken................
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission----------------------------------------------------------------------------
SkipVought
Programmer
Hi,
NO criteria
Check Unique Records only
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
NO criteria
Check Unique Records only
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Status
