Hello All,
I have a file of 40,000 unique codes that need to be assigned to customer records, dependent on the quantity of items they purchased. For every pair of items the customer purchased, they are entitled to 1 unique code (so, 6 items purchased, 3 unique codes assigned). These codes need to be deleted from the source list so that they can't be mistakenly reassigned. The customer records file contains NAME, CODE1, CODE2, (etc, up to CODE6), and ITEM QUANTITY. I could put IF statements in each of the CODE# fields that will look at the ITEM QUANTITY field, and copy a value if TRUE, however, I'm not sure how to go about making sure that code is a unique one from the source list. Is it possible to use a CUT/COPY function?
Hope this is clear enough.
Thanks in advance!
Bookmarks