Showing Duplicate rows in excel

[Jagz]

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

 

[Frank Kabel]

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

 

[Alan Beban]

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

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

=ArrayUniques(A:A) array entered into a column of cells of sufficient
number to accommodate the output.

Alan Beban

 

[Jagz]

Thanx Frank! It is indeed useful.....But one thing can i also filter
more than one row say Unique records in First second and third rows

eg
Row one contains -----1,jag,23
Row two contains -----2,man,34
Row three ----------------1,jag,23
Row four ------------------2,man,22
Row five -------------------2,jag,45

now i want the output should be four rows .......
in adv filter it will delete all duplicate rows with jag OR 1 OR 23 AS
THE CASE MAY BE
THANKS DEAR FRANK FOR THE PROMOT ANSWER AND HAPPY NEW YEAR