bongouni553
New Member
- Joined
- May 24, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi all
I need your assistance with the following on excel,
I need your assistance with the following on excel,
- The unique TransactionID consists of 13 characters. You need to create a function that will create this unique TransactionID.
- First four character: A combination of any four number of the alphabet (A-Z,a-z).
- Second group of four characters: The first four characters of the employeee number (0-9).
- Dash between the second and third group of characters.
- Next group of 3 characters: Random number between 100 and 999.
- Last number: Control number: The remainder when the last group of 3 numbers, is divided by 7. For example: 129 div 7 = 18 and the remainder is 4.
- I have for example employee number in one of my fields 1209090 in excel
- the transtacitonid should be like Abxy1209-1294
- I have a function with the following CHAR(RANDBETWEEN(65;90))&CHAR(RANDBETWEEN(65;90))&CHAR(RANDBETWEEN(65;90))&CHAR(RANDBETWEEN(65;90))&RANDBETWEEN(0;999) but its not working as desired .
- I need to also use the mod am stuck .