In an excel 2013 spreadsheet, Windows 10, how can I execute the following pseudo code in a macro, which I think will delete spreadsheet rows with duplicate first and last names:
from unknown last row n to row 1, step -1.
If cell(An)=cell(An-1) and cell(Bn)=cell(Bn-1), then
delete the entire row(n)
No comments:
Post a Comment