brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
I need to create a client reference code for each of my clients using this formula
=IF(B3="","",UPPER("C"&LEFT(C3,3)&G3&"001"))
This is done in column A
However if the formula creates a duplicate reference code it needs to make the last number 002 or 003 or 004 until the result is unique
Is there a way to do this in a formula?
=IF(B3="","",UPPER("C"&LEFT(C3,3)&G3&"001"))
This is done in column A
However if the formula creates a duplicate reference code it needs to make the last number 002 or 003 or 004 until the result is unique
Is there a way to do this in a formula?