Hello everyone,

I'm only familiar with the basics of Excel, and recently came across a need to narrow down some duplicate data within a single column. I'll try my best to explain what I'm shooting for. Any guidance is much appreciated.

I have ID numbers in a single column. Some of these ID numbers appear more than once in the same column. I'd like to run a filter (or something similar) to do 1 of 2 things:

Identify the cells with identical data and then only display those cells. This will at least help me identify how many times the same ID number appears in the column.

OR, better yet...

Identify identical data and only show 1 result for that match, so that only each ID number is only displayed once. This would be best (easiest) since it would let me know immediately how many unique ID numbers appear in the column.

Please let me know if additional info would help out.

Thanks all!