G

#### Guest

=if(and(s19>0,b8..b14000=b19),max(t8..t14000),0)

I want to check if value in s19 > 0 then

find the range equal to value in b19 in b8..b14000 then

find parallel range in t8..t14000 then

find maximum value in that range

That is value in b19 = 2, which there in b19 to b27 (b19 = 2, b20 =2, ....)

Now there is value in t19 is 25, t20 is 45, t21 is 5, t22 is 100... t27 is 75

maximum value between t19 to t27 is at t22 100, which is the value I require.

I want to copy the formula you give thro u8 ... u 14000

so that I get max value in "U" range.

my advance thanks to you..