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.
