Delete duplicate items in excel
Closed
bamster
-
May 17, 2011 at 12:38 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 17, 2011 at 09:52 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 17, 2011 at 09:52 PM
Related:
- Delete duplicate items in excel
- Number to words in excel - Guide
- Delete my whatsapp account without app - Guide
- Gif in excel - Guide
- All items in little alchemy - Guide
- Marksheet in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
May 17, 2011 at 09:52 PM
May 17, 2011 at 09:52 PM
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
