Extracting Duplicates

[Joe]

Thank you all for helping me and others with these
questions and problems.

Chip Pearson has two forumals that he uses to find unique
entries within a spreadsheet without using the Auto
Filter feature (can't use Auto filter). The first selects
all the unique entries in a range but also puts blank
cells in between, the second formula deletes the blank
cells, in a spreadsheet where I have thousands of rows of
information this takes a lot of realestate. Is there one
single formula that combines both of these? If so can
someone help me with it.

Thanks
Joe

 

[joe]

I found the answer in another post, I looked there first
but didn't see anything until now.

Thanks again Peo for your help and wisdom.

Best Regards
Joe