RANDBETWEEN but Exclude integers from two separate cells

[jworkman7]

If in A1 I have the integer 1, and in B1 I have the integer 3, and in C1 I want to generate a random number from 1 to 5 which excludes the integers 1 and 3 from these previous two cells, how could I accomplish this?

I looked over the below thread, but it was slightly different, and couldn't figure out how to make it work with my situation

http://www.mrexcel.com/forum/excel-questions/157520-randbetween-excluding-values.html

 

[pgc01]

Hi

For ex.:

=LARGE((1-COUNTIF(A1:B1,{1,2,3,4,5}))*{1,2,3,4,5},RANDBETWEEN(1,3))

 

[jworkman7]

Yes! Perfect. Thanks PGC

 

[pgc01]

You're welcome.