Condition Base Min & Max

[r_know]

Dear Friends,

I am looking for a min and maximum in between two hundred. These hundreds found in "C" columns, respectively (offset) "B" column checked to find the min and maximum value in that range to calculate the % for min & max value.

A sample file is attached in a very detailed explanation with highlighted cells.

Thanks, Regards R_know

Condition Base Min&Max.xlsm

[p45cal]

To give you a simple solution:
In D2:

=IF(AND($C2=100,$C3=""),MIN($B2:INDEX($B2:$B$1854,MATCH(100,$C3:$C$1854,0))),"")

in E2:

=IF(AND($C2=100,$C3=""),MAX($B2:INDEX($B2:$B$1854,MATCH(100,$C3:$C$1854,0))),"")

In F2:

=IFERROR(E2/D2-1,"")

Copy down.
Finally, to cheat, place 100 in cell C1854!

You might have to commit the formulae in columns D and E using Ctrl+Shift+Enter rather than the plain old Enter, depending on your version of Excel.

[r_know]

Many Thanks p45cal
I appreciated your quick response in simple ways...