ExcelBanter - how can i exclude dubble numbers in a vertical row

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how can i exclude dubble numbers in a vertical row (https://www.excelbanter.com/excel-discussion-misc-queries/225362-how-can-i-exclude-dubble-numbers-vertical-row.html)

Jan

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

Luke M

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

Per Jessen

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

All times are GMT +1. The time now is 07:08 PM.