I have list of thousands of numbers. I want to hide all aof the repeats and
have my list just show one of each number. Is there an easy way to do this. I
know how to sort the data so that all of the repeated numbers are grouped but
but i would take forever to manually hide them. I am using Excel 2007. Please
help