Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Repeat Data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Repeat Data
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 On Nov 12, 4:36 pm, Crystal wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeat data | Excel Discussion (Misc queries) | |||
Entering repeat data | Excel Discussion (Misc queries) | |||
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
Auto Repeat Data | Excel Worksheet Functions | |||
Repeat Cell Data | Excel Worksheet Functions |