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.

when i fill column A and B then C column generate Unique ID using RandBetween Formula {=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1000,9900)} ...
Solved by S. 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 - 09:22
Welcome! Thanks for choosing Got It Pro-Excel.
User 14/08/2017 - 09:23
Sir u understand what i say
User 14/08/2017 - 09:23
?
Excelchat Expert 14/08/2017 - 09:24
please confirm
Excelchat Expert 14/08/2017 - 09:24
Can you give me a sample result of your expected data?
Excelchat Expert 14/08/2017 - 09:25
your formula by the way is working good
User 14/08/2017 - 09:25
sir in first column when i enter the name and adress then in tird column the random number is generated by formula
User 14/08/2017 - 09:26
i want when i apply second column with name and adreesss automatically third colmn after that run the formula automatically
Excelchat Expert 14/08/2017 - 09:26
alright
User 14/08/2017 - 09:26
how its works ... is that possible
Excelchat Expert 14/08/2017 - 09:27
n there's no data, either of the 2 column, the formula will not run in column c
User 14/08/2017 - 09:27
yes
Excelchat Expert 14/08/2017 - 09:27
yes, that will be possible
Excelchat Expert 14/08/2017 - 09:27
- Entering Explanation Phase
User 14/08/2017 - 09:27
pls sir help me
Excelchat Expert 14/08/2017 - 09:27
sure
Excelchat Expert 14/08/2017 - 09:27
Alright, please give a moment to solve your posted problem.
User 14/08/2017 - 09:28
yes sir i'm waited here
Excelchat Expert 14/08/2017 - 09:30
- Entering Discussion Phase
Excelchat Expert 14/08/2017 - 09:30
The formula to resolve the issue is now created. Please check if we got the expected output.
User 14/08/2017 - 09:31
yes i already see ur moment in excel sheet
Excelchat Expert 14/08/2017 - 09:31
You may check
User 14/08/2017 - 09:31
yes sure sir
Excelchat Expert 14/08/2017 - 09:31
Great
Excelchat Expert 14/08/2017 - 09:31
This works for you now?
User 14/08/2017 - 09:31
yes that's good
User 14/08/2017 - 09:31
can u tell me how can i use this
Excelchat Expert 14/08/2017 - 09:31
Any more concern regarding this topic?
Excelchat Expert 14/08/2017 - 09:32
See, I've added an IF formula
User 14/08/2017 - 09:32
ok see i seen that ......... its works in excel 2007 ?
Excelchat Expert 14/08/2017 - 09:32
IF formula will make a test, if Either of column A or B will be blank
Excelchat Expert 14/08/2017 - 09:32
Then it gives a blank result at C
Excelchat Expert 14/08/2017 - 09:33
If completed for A and B, then it performs the formula RANDBETWEEN
User 14/08/2017 - 09:33
its not work in 2007 excel
Excelchat Expert 14/08/2017 - 09:33
any error on it
User 14/08/2017 - 09:34
i thing the code will be apply on whole column in 2007
Excelchat Expert 14/08/2017 - 09:35
By the way, what is the problem pops up in excel 2007
Excelchat Expert 14/08/2017 - 09:35
the error message
User 14/08/2017 - 09:35
instead use of (A2... B2)
Excelchat Expert 14/08/2017 - 09:35
we must use the 2,
Excelchat Expert 14/08/2017 - 09:35
A2 and B2,
Excelchat Expert 14/08/2017 - 09:35
They are being tested to get the logical result of TRUE
Excelchat Expert 14/08/2017 - 09:36
If FALSE, then it will be blank result in C column
User 14/08/2017 - 09:36
sometime its works on excel 2007 and sometimes not
Excelchat Expert 14/08/2017 - 09:37
What's the result when it does not work?
Excelchat Expert 14/08/2017 - 09:37
the kind of error/
Excelchat Expert 14/08/2017 - 09:38
just wanting to know, so we can resolve it. At this time it works on our sample
Excelchat Expert 14/08/2017 - 09:39
Hope the explanation and Discussion in this excel helps
User 14/08/2017 - 09:40
somewhat bt creating problem in 2007
Excelchat Expert 14/08/2017 - 09:40
yes, maybe some features on your Excel 2007 now not working
Excelchat Expert 14/08/2017 - 09:41
we do have latest version now that are free, by the way
Excelchat Expert 14/08/2017 - 09:42
Thank you for coming at Got It Pro-Excel!
Excelchat Expert 14/08/2017 - 09:42
Have a good day ahead!

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