**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.*