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