Merge the two formulas together?

[Dougiebn]

Merge the two formulas together?

First formula:
=INDEX(A6:A99,MATCH(LARGE(IF(B6:B99="m",AG6:AG99,""),1),AG6:AG99,0))

Second formula:
=MAX(IF(AG6:AG99<180,AG6:AG99,""))

As long as the value is less than 180

Thanks in advance.

Doug
​

 

[Gerald Higgins]

Hi, welcome to the board.

There are (possibly infinitely) many ways of merging the two formulas together.

But to do that in the way that YOU want, can you explain what the formulas should do, exactly, once they have been merged ?
Sorry, but this is not obvious to me.

 

[VoG]

Cross posted Merge the two formulas together?

 

[Dougiebn]

Sorry about the cross-post :Merge the two formulas together?