Need some help on coming up with random number from 2 excel columns.

[webuxer]

Hi, I need some help in coming up with some random numbers from 2 columns in an excel file.

If you see on the attached file on column F and G there are some numbers. I need to come up with some random numbers and put them in column H. But the number from column F needs to be a few numbers higher (sometimes a number up, or 2 numbers up, up to three numbers up, but they need to be random throughout the whole column, (like I said sometimes 1 or 2 or 3 numbers up). On column G is the same but the numbers need to go down by 1 or 2 or 3 numbers, just random numbers. On the results on the H column the left number needs to be smaller than the right number. If you see on the attached file the first result in column H .428 is lower than .440 (The number on the left needs to smaller. I'm really trying to come out with a formula but I cant figure it out. Its a long list maybe someone can help me on this if is even possible.

Thanks in advanced

 

[bschwartz]

Does this work for you?

Excel 2010
	F	G	H
1	0.427	0.447	0.429 - 0.445
2	0.205	0.225	0.208 - 0.224
3	0.053	0.073	0.056 - 0.07
4	0.053	0.073	0.055 - 0.07
5	0.05	0.07	0.052 - 0.068
randb

Cell Formulas
Range	Formula
H1	=RANDBETWEEN(1,3)/1000+F1&" - "&-RANDBETWEEN(1,3)/1000+G1

 

[webuxer]

Does this work for you?

Excel 2010

	F	G	H
0.429 - 0.445
0.208 - 0.224
0.056 - 0.07
0.055 - 0.07
0.052 - 0.068

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]0.427[/TD]
[TD="align: right"]0.447[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]0.205[/TD]
[TD="align: right"]0.225[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]0.053[/TD]
[TD="align: right"]0.073[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]0.053[/TD]
[TD="align: right"]0.073[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]0.05[/TD]
[TD="align: right"]0.07[/TD]

</tbody>

randb​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]H1[/TH]
[TD="align: left"]=RANDBETWEEN(1,3)/1000+F1&" - "&-RANDBETWEEN(1,3)/1000+G1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you soo much this is what i needed, can it be possible to be able to have a number on your sample
on Row 3, the result for 0.073, instead of 0.07 be something like 0.071. I would like to keep the same amount of numbers.
Thanks

<table cellpadding="2.5px" rules="all" verdana,="" arial,="" tahoma,="" calibri,="" geneva,="" sans-serif;="" border:="" 1px="" solid="" rgb(187,="" 187,="" 187);="" border-collapse:="" collapse;"="" width=""><tbody></tbody></table>

 

[bschwartz]

Try this:

=TEXT(RANDBETWEEN(1,3)/1000+F1,"0.000")&" - "&TEXT(-RANDBETWEEN(1,3)/1000+G1,"0.000")

 

[webuxer]

Thanks you so much for your help, you have answered my question. Thanks for your time. I have another question but I will put it in another thread.
Thanks

 

[bschwartz]

You're most welcome.