Showing Duplicate rows in excel
 

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

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

Jagz wrote:
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

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