Is it possible to have small array consisting of two different rows of values?

[aedctalk]

Hello.

I'm curious if i can pull a small value out of two sperate rows within one array?


Is there a way to look for smallest in both F42:AS42 AND F112:AS112 all in one array?


Right now i'm using:

=SMALL(IF(F42:AS42=0,0,F42:AS42),1) in cell ax147
=SMALL(IF(F42:AS42=0,0,F42:AS42),2) in cell ax148

and then

=SMALL(IF(F112:AS112=0,0,F112:AS112),1) in cell ax149
=SMALL(IF(F112:AS112=0,0,F112:AS112),2) in cell ax150

and then to get the top three

I'm pulling the Small 1 , 2 , 3 from range ax147:ax150


That'd really help take out a ton of code!

 

[Domenic]

Try...

=SMALL((F42:AS42,F112:AS112),1)

 

[aedctalk]

Thank you! Works wonderful!

Saved me a ton of extra code i had been using :P

 

[Domenic]

You're welcome! Thanks for the feedback!