VBA Macro

[yogeshwadhwani]

Hi,

I need a Marco formula to find max value,

Data starts from 6th row,

Column A = TIME
COLUMN B = DATA
COLUMN C = COND

Cond is c6 = IF(b6>10,"YES","")

Say on c16 I get YES, and last row is a32, i need =max(b16:b32)
in cell F2.


Thanks & Regards,

Yogesh

 

[Armando Montes]

Perhaps something like this:
=MAX(IF(C16="YES",B16:B32))

 

[yogeshwadhwani]

It's ongoing process next row can be c36 with "YES"
then the value needed will be F2=max(b36:lastrow)

 

[Armando Montes]

=max(if(c16="yes",b16:b$3200))