Hello
I'm looking for a formula that would blank out cells in Column B and not delete the entire row when duplicate data is found but the trick is that it needs to be based on when there is duplicate data in column A then it should just keep one value in column B and all other values related to that other column should be blank.
Column A Column B
ABC 123
ABC 123
ABC 123
DEF 456
DEF 456
DEF 456
So my result should be like this
Column A Column B
ABC 123
ABC
ABC
Thank you.
Bookmarks