I have data that looks like this:
![]()
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 2 1 1 1 2 2 2 2
I want to check A1 if there are ducplicates delete contents of the cell![]()
I want 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 2 2 2 2
I have data that looks like this:
![]()
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 2 1 1 1 2 2 2 2
I want to check A1 if there are ducplicates delete contents of the cell![]()
I want 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 2 2 2 2
Hi johnph,
why you left two 2 in our result set ? Are you looking complete row instead of a1 (column A) as you mentioned ?
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks