**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have 4 column. when i fill the first 3 column. in 4th column i need a unique id number and i generate unique id number using RANDBETWEEN formula [ =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1000,9900) ]
but i want ..... when i'm filling the 3 column after that 4th column run this formula and generate unique id automatically

Solved by X. Q. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
14/08/2017 - 10:50

Hello! Thanks for choosing Got It Pro-Excel.

Excelchat Expert
14/08/2017 - 10:51

hello

User
14/08/2017 - 10:51

now see sir .... again i copy the code and then paste then i get the unique random number

User
14/08/2017 - 10:51

hello sir

Excelchat Expert
14/08/2017 - 10:52

alright running good

User
14/08/2017 - 10:52

yes sir but i have some problem sir

Excelchat Expert
14/08/2017 - 10:52

is that your 3 columns now

User
14/08/2017 - 10:52

yes sir

Excelchat Expert
14/08/2017 - 10:52

okay

Excelchat Expert
14/08/2017 - 10:52

so what will we do at your 4 column/

Excelchat Expert
14/08/2017 - 10:53

you've mentioned 3 column, then 4th column will be?

User
14/08/2017 - 10:53

now its ok sir

Excelchat Expert
14/08/2017 - 10:53

okay

User
14/08/2017 - 10:53

sir i want

User
14/08/2017 - 10:54

when i enter the name after that address and after that contact number .... the 4 column run automatically the ranbtween formula for generating the unique code

Excelchat Expert
14/08/2017 - 10:55

alright, so when the Name, address and contact column is complete, then generated a unique ID number at the 4th column, right/

User
14/08/2017 - 10:55

yes absolutely right sir

Excelchat Expert
14/08/2017 - 10:56

- Entering Explanation Phase

Excelchat Expert
14/08/2017 - 10:56

Please give me few minutes to resolve the issue now?

User
14/08/2017 - 10:56

yes sir .... i'm waiting here

Excelchat Expert
14/08/2017 - 10:56

thanks ;0

Excelchat Expert
14/08/2017 - 10:59

- Entering Discussion Phase

Excelchat Expert
14/08/2017 - 10:59

I’ve completed the solution, please take a look if you would like. We can now continue to the discussion stage and answer any questions you may have with the solution I provided.

Excelchat Expert
14/08/2017 - 11:00

Alright, does this solution works for you now?

User
14/08/2017 - 11:00

ohk its means ..... i have to apply this code firstly all the column

User
14/08/2017 - 11:00

does it work in 2007 Excel ?

Excelchat Expert
14/08/2017 - 11:00

oh yes, ready for generating ID uniquely

Excelchat Expert
14/08/2017 - 11:01

This is applicable in 2007 too, as it says the function works on it

User
14/08/2017 - 11:01

when i apply this code in column the unique code generate at the time ... how i apply code in cells without generating it

Excelchat Expert
14/08/2017 - 11:01

By the way, does your previous formula works on Excel 2007?

User
14/08/2017 - 11:02

yes sir its works in previous version

Excelchat Expert
14/08/2017 - 11:02

great

Excelchat Expert
14/08/2017 - 11:02

this will work the same on your Excel too

Excelchat Expert
14/08/2017 - 11:02

you may try it

User
14/08/2017 - 11:03

sir as u see ... u apply code in A7 without generating it ... how can i ? when i apply it generate code at the applying time

Excelchat Expert
14/08/2017 - 11:04

That code is ready to check data, that's why it has been input immediately

User
14/08/2017 - 11:04

ok wait for a minute

Excelchat Expert
14/08/2017 - 11:04

ut it will only generate a uniqe ID as soon as it satisfies the 3 required columns

Excelchat Expert
14/08/2017 - 11:05

these formula are ready to generate only anytime as you complete the details of the 3 column

Excelchat Expert
14/08/2017 - 11:05

does the explanation makes sense now?

User
14/08/2017 - 11:06

sir when i complete the 3 column and my cursor is on the 4th column ...... no result generate .... until i'm again click on the formula panel and just click back to the cells

Excelchat Expert
14/08/2017 - 11:06

hopefully, this formula and explanation helps you

Excelchat Expert
14/08/2017 - 11:06

oes it?

User
14/08/2017 - 11:07

not in ur pro version ... is in 2007 excel version

Excelchat Expert
14/08/2017 - 11:07

no need to go at the 4th column, when you completed the 3 column

User
14/08/2017 - 11:08

i think its not work in 2007

User
14/08/2017 - 11:08

but ur answer is version useful for me

Excelchat Expert
14/08/2017 - 11:08

So, the version of excel is now the problem

Excelchat Expert
14/08/2017 - 11:08

ot the formula

User
14/08/2017 - 11:08

i think so

Excelchat Expert
14/08/2017 - 11:09

and not the formula

Excelchat Expert
14/08/2017 - 11:09

well, so great to know it works on you

User
14/08/2017 - 11:09

yes sir .... really thank you

Excelchat Expert
14/08/2017 - 11:09

your welcome

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*