I have a worksheet (about 75x2770) each 'data-object' or row has a unique excel id. There are duplicates from how the data was loaded into excel - the excel ID allows me to easily find the duplicates. I would like to keep a row based on the contents of 2 independent cells (in the same row).
the logic would be something like this:
look in column BK "where the unique excel IDs are)
tag duplicates and sort
for each set of duplicates delete all but one, based on:
````look in column AC; where it says either a, b, or c; let a=1 b=2, c=3
```` look in column X: where it will say 1, 2 or 3.
delete row(s) with same ID if 1==1, 2==2, 3==3 is not true.
would greatly appreciate any help. I'd really like to be able to do this inside excel.
Thanks,
james
the logic would be something like this:
look in column BK "where the unique excel IDs are)
tag duplicates and sort
for each set of duplicates delete all but one, based on:
````look in column AC; where it says either a, b, or c; let a=1 b=2, c=3
```` look in column X: where it will say 1, 2 or 3.
delete row(s) with same ID if 1==1, 2==2, 3==3 is not true.
would greatly appreciate any help. I'd really like to be able to do this inside excel.
Thanks,
james
