buclao
09-21-2011, 03:12 PM
First of all, thank you for taking the time to read this and thank you for your support.
I have 2 columns, A and B. In column A I have defined an ID and on Column B I have defined a criteria on wether the row for the ID should be deleted or not. What Im trying to do is look up for duplicate values on the column A and then look up on the Column B to see if the row should be deleted or not. In case that there are duplicates for both columns I would like to highlight those cells in yellow and don't delete them at all. Any1 with an idea on where to begin or what type write first?
Thanks in advance!
I have 2 columns, A and B. In column A I have defined an ID and on Column B I have defined a criteria on wether the row for the ID should be deleted or not. What Im trying to do is look up for duplicate values on the column A and then look up on the Column B to see if the row should be deleted or not. In case that there are duplicates for both columns I would like to highlight those cells in yellow and don't delete them at all. Any1 with an idea on where to begin or what type write first?
Thanks in advance!