Only Display Duplicate Numbers One time

dlewis61 used Ask the Experts™
I have a list of numbers, and a lot are repetitive. I'd like to make it so the numbers are displayed only once, so duplicates only show one time.
Pivot table doesn't seem to work because I have one column. How can I do this? There are over 3495 numbers, so a filter isn't an option....
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Serena HsiMarketing Consultant

A pivot can work. You'd just be doing a count instead of cross-tabbing it with something else. Also, Excel can 'remove duplicates' as well.


quick fix thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial