Index match ignoring zero values (help)

[pujo]

How can I make this formula ignore blanks and zero values?

=INDEX(O9:BV9,MATCH(MIN(O10:BV10),O10:BV10,0))

Thanks,
Pujo

 

[ExcelElliott]

Hi Pujo

In place of MIN(O10:BV10), try AGGREGATE(15,7,(O10:BV10)/((O10:BV10<>0)*(O10:BV10<>"")),1)

Hope that helps.

 

[pujo]

Thanks Elliott however, this does not work for me. I am still using Excel 2010 (i know)...
I get errors in the formula.

 

[ExcelElliott]

Ok, try the following

MIN(IF(O10:BV10<>0,IF(O10:BV10<>"",O10:BV10)))

Confirm by pressing Ctrl + Shift + Enter.

 

[Fluff]

The Aggregate formula should work for 2010

Excel 2013/2016
	N	O	P	Q	R	S	T	U	V
9		O	P	Q	R	S	T	U	V
10	T	11		0	7		5	6
Data

Cell Formulas
Range	Formula
N10	=INDEX(O9:BV9,MATCH(AGGREGATE(15,7,(O10:BV10)/((O10:BV10<>0)*(O10:BV10<>"")),1),O10:BV10,0))