ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to delete repeated numbers in a column, make it apears once (https://www.excelbanter.com/excel-discussion-misc-queries/182406-how-delete-repeated-numbers-column-make-apears-once.html)

Sam

how to delete repeated numbers in a column, make it apears once
 
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

muddan madhu

how to delete repeated numbers in a column, make it apears once
 
Use Data | Filter | Advanced Filter

On Apr 3, 10:18*pm, sam wrote:
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




All times are GMT +1. The time now is 01:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com