Hi all,
I am new to this forumn. I have a problem in removing duplicates. say in a2:a100 i have results like
yes
yes
no
no
yes
no
yes
yes
no
and so on.
I want to remove and replace with blank rows for the duplicates comes in between one YES and one NO in that column.leaving already blank rows unaltered.
I request my seniors in this forum to help me out in this regard
Thanks in advance
Bookmarks