4440558 4440558 4440558 1234567 1234567 all i want is that i see every number once
J Jan Mar 24, 2009 #1 4440558 4440558 4440558 1234567 1234567 all i want is that i see every number once
L Luke M Mar 24, 2009 #2 Select your data range, then go to Data-filter-Advanced Filter. For the Criteria box, input the range ocntaining your numbers, then check the box "unique records only". Then filter.
Select your data range, then go to Data-filter-Advanced Filter. For the Criteria box, input the range ocntaining your numbers, then check the box "unique records only". Then filter.
P Per Jessen Mar 24, 2009 #3 Use the Advanced filter option from the Data menu and check "Unique records only" Regards, Per