Hi Every1.
I have an Excel worksheet that contains 4 columns.
I select column A and B, and add a conditional formatting to change the color of DUPLICATE cells to a color. So, some cells in column A and B turn to color.
Here is what I want to accomplish:
NO CHANGE TO COLUMN A.
Delete cells in column B,C,D that the B is NOT colored (there is no match in column A), and of course, move cells up in B,C,D.
The goal is to get rid of cells in column B,C,D where the B doesn't exist in A.
I hope I could make myself understood well.
I have attached a screenshot.
Thank you so much.
I have an Excel worksheet that contains 4 columns.
I select column A and B, and add a conditional formatting to change the color of DUPLICATE cells to a color. So, some cells in column A and B turn to color.
Here is what I want to accomplish:
NO CHANGE TO COLUMN A.
Delete cells in column B,C,D that the B is NOT colored (there is no match in column A), and of course, move cells up in B,C,D.
The goal is to get rid of cells in column B,C,D where the B doesn't exist in A.
I hope I could make myself understood well.
I have attached a screenshot.
Thank you so much.