Hello all!
I have a long list (3000 or so) of unique codes. On another sheet, I have a list of customer name, customer email address, and the number of purchases they have made. I am trying to figure out a way to drop in codes on this 2nd sheet based on the number of purchases they have made, and not drop in one code more than one time.
Ex. If John Smith purchased 3, I would like codes one to three to be inserted in the same cell next to this customer.
Then, the next customer purchased 5, so I would like codes four to eight to be put in the same cell next to this customer.
Can anyone help or point me in the right direction?
Thanks!
Bookmarks