dbcooper88
New Member
- Joined
- Dec 3, 2016
- Messages
- 36
Array formula is {=AVERAGE(IF(ISNUMBER(MATCH(I13:I18,SMALL(I13:I18,{1}),0)),(H13:H18)))}. Want to ignore the #DIV/0! error and use the cell in column H corresponding to the I column having the #DIV/0! error.
TIA
TIA