I have imported data into an Excel spreadsheet containining approximately 1500 records. Within this spreadsheet there are duplicates for some (not all) of the records. If the account number in one column and the address in another column are an exact match for two records, I need to combine/consolidate into one row. Any quick tips on how to do this? I am searching for macro formulas but perhaps there is an easier solution? Suggestions appreciated! Thank you!
Bookmarks