0
138
ViewsMin - second lowest number using non adjacent ranges
I understand the min formula as a standard and have created the below formula to find the min value across to non adjacent ranges
But what I need is to find the second smallest number but am experiences many errors
this returns the value of 2, and if i add indirect I receive an error, any thoughts on the correct way of finding the second lowest number from non adjacent ranges?
=MIN(INDIRECT(("G14:I12", "K14:M14"),2))
·
Santiago Trujillo
1 answers
Answer question0
If you want second minimum number then could try SMALL() function. Try-
=SMALL(G2:M2,2)
·
Santiago Trujillo
Report
Answer question