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.