Wednesday, August 27, 2014

Excel macro to search for duplicate names in all rows

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

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...