Hi All,
I would like to do a VLookup to solve an accounting problem. My data gives the same order ID on multiple lines. In order to make the VLookUp work I need to change the duplicated order ID's too unique ID's. In the example you will notice 112-4526136-7587448 is listed 6 times so I need 112-4526136-758744801 then 112-4526136-758744802 .....
Some will have many more than just 6 rows maybe 50 or 60.
Thanks
Bookmarks