choose random value from non-contiguous range

[ilcaa]

i have a non-contiguous range and i wanted to select a random value from this range, best way? so range is everything except red values

Q4RF_tus_satData.xlsm
	N	O	P	Q
5	9.0%	5.0%	1.7%	4.8%
6	6.9%	-15.9%	13.5%	7.1%
7	5.5%	-18.3%	0.0%	1.0%
8	1.5%	20.0%	-0.1%	-6.5%
9	11.8%	24.8%	-2.4%	3.1%
10	-4.0%	1.5%	7.1%	-2.7%
11	11.4%	-5.8%	0.9%	11.6%
12	-3.8%	0.5%	2.6%	-1.8%
13	3.8%	7.0%	4.8%	5.9%
14	-3.2%	-1.4%	0.5%	6.5%
15	3.6%	-7.0%	-0.4%	7.0%
comparisionTables

Cell Formulas
Range	Formula
N5:Q12,N13:P15	N5	=(N38-N37)/N37

 

[Z51]

Not sure what formula/code you're using to select a random cell, but you can name the range by selecting those cells and clicking Formulas > Define Name (in Defined Names section). Give it a name, e.g. myRandomRange and click OK.

You can then refer to that range in formulas or code.

=MIN(myRandomRange)
=AVERAGE(myRandomRange)

etc...