Forum Discussion
Solved
Formula Help, Please!
The above is an example of data in which I would like to have a combination of functions that will return a value from row 1 dependi...
Anthony,
try this:
=AGGREGATE(15,6,C1:G1/(INDEX(C4:G9,MATCH(B12,B4:B9,0),0)>C13),1)
Anthony,
try this:
=AGGREGATE(15,6,C1:G1/(INDEX(C4:G9,MATCH(B12,B4:B9,0),0)>C13),1)