Random Number based on Customer ID

  • Hoping someone can help me. I have included a sample spreadsheet. I need to generate a random customer ID number to send to a vendor as a replacement for my customer ID. Each customer occupies a different number of rows, so I need the same random number to populate next to each Customer ID. (Although not shown, each column to the right of the customer ID has various information about specific transactions the customer has completed.)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!