Shane is right - more info and clarification would help, but in the meantime,
IF you want to examine the list and get a list of unique entries in it (try
his recommendation also), you can use these formulas to list the unique
values in a column.

Assume your data is in column A and begins at row 1 (and goes down to 512 in
my test case). Column C is now empty, and is available for this use, so our
first formula goes into C1
=A1
that echos the value from A1 and 'seeds' the rest of the formulas
in C2 put
=IF(COUNTIF($C$1:C1,A2)0,"",A2)
fill that formula down to the end of your list. Unique entries will appear
at the first row they are encountered in the original list. Maybe that will
give you a kick start.


"jerry" wrote:

I need to count how many unique records (rows) there are so hiding rows. Is
there any macro or function that will dedupe to display a single entry for a
unqiue cell entry.