| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can i exclude dubble numbers in a vertical row
4440558
4440558 4440558 1234567 1234567 all i want is that i see every number once |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i exclude dubble numbers in a vertical row
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jan" wrote: 4440558 4440558 4440558 1234567 1234567 all i want is that i see every number once |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can i exclude dubble numbers in a vertical row
Use the Advanced filter option from the Data menu and check "Unique records
only" Regards, Per "Jan" skrev i meddelelsen ... 4440558 4440558 4440558 1234567 1234567 all i want is that i see every number once |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add numbers in a column, but exclude percentages in the same colum | Excel Worksheet Functions | |||
| find first non-zero value in a vertical list of numbers | Excel Discussion (Misc queries) | |||
| GENERATE RANDOM NUMBERS BUT EXCLUDE A NUMBER IN THE SEQUENCE | Excel Discussion (Misc queries) | |||
| How do I compare a vertical column of numbers to another verical . | Excel Discussion (Misc queries) | |||
| Count 350 SS numbers, exclude duplicates | Excel Discussion (Misc queries) | |||
Hybrid Mode
