I have some duplicate data which I need to highlight so I can delete. What complicates this is that to determine what's a duplicate I need to look at multiple columns.
The data is in columns A and B, and I want to remove the duplicate data from col B. So normally I'd just set a conditional format on col B and then delete the duplicates. But in this case col B is just dollar values, so a lot of valid data would show up as a duplicate. I only want to delete data in col B IF the corresponding cell in col A is also a duplicate.
How would I do that?
The data is in columns A and B, and I want to remove the duplicate data from col B. So normally I'd just set a conditional format on col B and then delete the duplicates. But in this case col B is just dollar values, so a lot of valid data would show up as a duplicate. I only want to delete data in col B IF the corresponding cell in col A is also a duplicate.
How would I do that?