Hello,
I need 2 things.
1. I need a formula in my excel spreadsheet that picks up duplicates. The range for the duplicates would be within 1 column. Right now I have:
=COUNTIF(A:A,A1)>1
which basically counts if it comes up more than once, then reading either true or false.
<tbody>
</tbody>
However, I need something that can recognize if there are duplicates given circumstances with 2 columns (in this case, looking at "Name" and "Cost Center" criteria), giving me something like this after removing the duplicates:
<tbody>
</tbody>
So it delete the duplicate row with "Tony Yoo" and cost center "1001".
2. To sum it all up, I was thinking of putting this into VBA to automatically look for these duplicates and then remove.
I know this is long but any advice is appreciated!!!
Thank you,
Tony
I need 2 things.
1. I need a formula in my excel spreadsheet that picks up duplicates. The range for the duplicates would be within 1 column. Right now I have:
=COUNTIF(A:A,A1)>1
which basically counts if it comes up more than once, then reading either true or false.
Name | Cost Center | |
Tony Yoo | 1001 | True |
Tony Yoo | 1001 | True |
Bob Marley | 9999 | False |
Tony Yoo | 5555 | True |
<tbody>
</tbody>
However, I need something that can recognize if there are duplicates given circumstances with 2 columns (in this case, looking at "Name" and "Cost Center" criteria), giving me something like this after removing the duplicates:
Name | Cost Center | |
Tony Yoo | 1001 | True |
Bob Marley | 9999 | False |
Tony Yoo | 5555 | True |
<tbody>
</tbody>
So it delete the duplicate row with "Tony Yoo" and cost center "1001".
2. To sum it all up, I was thinking of putting this into VBA to automatically look for these duplicates and then remove.
I know this is long but any advice is appreciated!!!
Thank you,
Tony