@jdraw: Thank you for your response. I completely agree with your thinking and would have responded the same way. If the "refnum" is unique, what's the point of creating another unique ID.
My issue is that I can't control the way I get data at my company. I have to go thru a macro-enabled...
Hello and thank you in advance!
I apologize in advance for my lack of experience in how to create properly aligned examples below.
I have a month's worth of shipment data in a table. The first field in this table is "refnum" which is the unique identifier of this shipment. "refnum" is...