All solutions COLUMNS Expert Solution – Excel COLUMN Problems

Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc