View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
use 'Data - Filter - Advanced Filter' and check 'Unique entries'
or use the following addin:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany
"Jagz" schrieb im Newsbeitrag
ups.com...
Hi Friends!

I want to show the unique rows in a columns....say in ColA there are
100 filled cells and out of which only 65 are unique....
I want to list only unique entries.....
It is very difficult to sort all the entries individually
IF anybody help me out......

By

Jagjeet Singh