Hello, I'm creating a macro to automatically create a spreadsheet based on raw data exported daily. The whole spreadsheet is sorted alphabetically by region first (there are only 3 regions though, so there are several duplicates for each). In A3:A30 I have the regions of my company, lets' call it Region A, B, & C. How can I merge the cells automatically so that there is only one entry per region; in essence there should only be 3 cells in column A - one for each region...Makes sense?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Duplicate Values Question
- Thread starter rserrano
- Start date
Similar threads
- Solved
- Question
