Hi all--I'm an excel newbie so having a hard time explaining the things I'm trying to do, please forgive me!
In my spreadsheet I have many phone numbers, some of which have corresponding codes 6 cells to the right.
The codes are typed in when the list of phone numbers is filtered for unique values, so after we are done assigning codes, we have to go back in and apply more filters to ensure each phone number has the right code. It takes too much time to filter/copy/paste one by one.
Could anyone help me write a script that will label the correct codes to the duplicate phone numbers once we are done assigning the first case of that phone number?
I've attached a dummy file so you can see what we are trying to do. Would appreciate any help!
Bookmarks