Delete duplicate items in excel
Closed
bamster
-
17 May 2011 à 12:38
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 17 May 2011 à 21:52
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 17 May 2011 à 21:52
Related:
- Delete duplicate items in excel
- Delete duplicates in excel - Guide
- Little alchemy all items - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Arrow keys not working in excel - Guide
- How to duplicate data from one excel sheet to another - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
17 May 2011 à 21:52
17 May 2011 à 21:52
suppose data is from A1 to aA7
in some empty cell below e.g. A15 copy this formula
=IF(COUNTIF(A1:$A$7,A1)>1,"",A1)
copy A15 down till you get 0
you can delete blank rows in rows 15 down.
another method is use advance filter
read excel help for this
in some empty cell below e.g. A15 copy this formula
=IF(COUNTIF(A1:$A$7,A1)>1,"",A1)
copy A15 down till you get 0
you can delete blank rows in rows 15 down.
another method is use advance filter
read excel help for this
