Showing Duplicate rows in excel

J

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
 
A

Alan Beban

Jagz said:
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
Click to expand...
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
 
J

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
 
Top