Extract

[sajith]

Month Number
AUG 1
AUG 2
AUG 3
AUG 4
AUG 5
AUG 6
SEP 28
SEP 29
SEP 30
SEP 31
SEP 32
SEP 33

these r the data given in Sheet 1 and i want the highest number in the month
of august in sheet 2

 

[Bob Phillips]

=MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200))

this is an array formula, so commit with Ctrl-Shift-Enter not just Enter

 

[sajith]

i got the result as 33 but its not true, i want the highest number only for
the period of AUG

 

[Dave Peterson]

Bob's formula worked fine for me.

Are you sure you didn't miss the Aug with 33? Maybe in a hidden/filtered row?

 

[sajith]

i am getting the result as 33, but the highest number for the month of AUG is
6. the highest number for the month of SEP is 33. i want to get the highest
number for the month of AUG on sheet 2.

 

[Dave Peterson]

Share your formula.

i am getting the result as 33, but the highest number for the month of AUG is
6. the highest number for the month of SEP is 33. i want to get the highest
number for the month of AUG on sheet 2.

 

[sajith]

i was using bobs formula =MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200))

 

[Dave Peterson]

I would double check the data.

I think you have that value for Aug.

i was using bobs formula =MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200))