I have this issue. I have two columns, sometimes the contents(text) are the same on one row. I would like to delete the content from second column in case it matches the previous cell...Any help?
I have this issue. I have two columns, sometimes the contents(text) are the same on one row. I would like to delete the content from second column in case it matches the previous cell...Any help?
Last edited by vrzy; 10-08-2015 at 07:58 AM.
Try
Assuming column A and B to treat
In column C put
C1 =IF(A1=B1,"",B1), copy and paste done as needed
Copy column C and paste values in column B
- Battle without fear gives no glory - Just try
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks