Generating a unique consecutive or random code of two letters and numbers

In an app I´m creating I need to generate a random or consecutive (it´s the same) code of two letters, and this to be the initial value on a cell. It must be unique.

The user will be able to change it, so the app must check that the code is not being used. This last thing I know how to check, but any ideas are welcome. 

To be specific... I need this kind of values:

AA, FD, Z1, X9, DG, KK, LO

Thanks

 

Solved Solved
0 12 1,929
1 ACCEPTED SOLUTION

Steve
Platinum 5
Platinum 5

LEFT(UNIQUEID(), 2)

View solution in original post

12 REPLIES 12
Top Labels in this Space