Hide Repeat Data

G

Guest

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
 
P

Pete_UK

Assuming all your numbers are in column A, beginning with A2, you can
use a formula like this in a blank column:

=IF(COUNTIF(A$2:A2,A2)>1,"Hide","Show")

and copy this down your list of numbers.Then apply autofilter to the
column with the formula in and select Show from the pull-down.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use pivot table to count repeats of unique fields 4
Count quantity of repeated items in a column 4
Hide Some Text in a Cell 4
Can i hide parts of a Pivot tables subtotals??? 2
Import large number string 1
Counting Repeated text or duplicates in a list 5
macro showing and hiding detail 1
Data validation with dropdown list 2

Top