how to delete repeated numbers in a column, make it apears once

S

sam

how to eliminate repeated numbers/characteres in a column,
e.g
22
22
23
24
24
24
how to make the numbers appear only once.how to delete it if i have a long
list
 

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

Transposing 0
Conditional SUBTOTAL in XL210 Table 7
Count quantity of repeated items in a column 4
Delete Repeated Data? 3
How to determine the occurrence? 9
Copy row to new sheet if cell data is repeated more than 3 times 2
Delete rows with duplicated values 2
Error when using Sum command 3

Top