Ignoring "NA" for min/max

[emutuc]

Greetings to all on Mr. Excel,

I'm seeking your help on a formula where I want to find the minimum of an array of numbers, from 3 different columns, while ignoring all "NA".
May I have your suggestions?

Thank you for your time and willingness

 

[emutuc]

That ignores negative numbers as well as zero but in any case the single function formula ..
=AGGREGATE(15,6,A1:H1/(A1:H1>0),1)
.. would do the same job as that.

Both of the above formulas would rely on the cells between the yellow ones (which we know nothing about) not containing numbers, hence the structure of my previous suggestion.

22 12 24.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	10	a	#N/A	0	5	3	d	0			5	3
Min

Cell Formulas
Range	Formula
C1	C1	=NA()
K1	K1	=LET(r,INDEX(A1:H1,{1,3,5,8}),AGGREGATE(15,6,r/(r<>0),1))
L1	L1	=MIN(IF(IFERROR(A1:H1,0)>0,IFERROR(A1:H1,0)))
Press CTRL+SHIFT+ENTER to enter array formulas.

Thank you, this solves it. I like this one, not as complicated

 

[emutuc]

=MIN(IF(IFERROR(A1:H1,0)>0,IFERROR(A1:H1,0)))

Many thanks! this worked!!

 

[emutuc]

You're welcome. Thanks for the confirmation.



Here is one way but it would not be applicable if your cells are actually on different sheets as indicated in post #2.
Trying to find the minimum of the yellow cells, ignoring error values and zero.

22 12 24.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	10		#N/A		5			0			5
Min

Cell Formulas
Range	Formula
C1	C1	=NA()
K1	K1	=LET(r,INDEX(A1:H1,{1,3,5,8}),AGGREGATE(15,6,r/(r<>0),1))

Thank you Peter_SSs

 

[Peter_SSs]

Glad we could help. Thanks for the feedback.