|
Extract
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 |
Extract
=MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200))
this is an array formula, so commit with Ctrl-Shift-Enter not just Enter -- __________________________________ HTH Bob "sajith" wrote in message ... 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 |
Extract
i got the result as 33 but its not true, i want the highest number only for
the period of AUG "Bob Phillips" wrote: =MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200)) this is an array formula, so commit with Ctrl-Shift-Enter not just Enter -- __________________________________ HTH Bob "sajith" wrote in message ... 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 |
Extract
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 wrote: i got the result as 33 but its not true, i want the highest number only for the period of AUG "Bob Phillips" wrote: =MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200)) this is an array formula, so commit with Ctrl-Shift-Enter not just Enter -- __________________________________ HTH Bob "sajith" wrote in message ... 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 -- Dave Peterson |
Extract
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" wrote: 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 wrote: i got the result as 33 but its not true, i want the highest number only for the period of AUG "Bob Phillips" wrote: =MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200)) this is an array formula, so commit with Ctrl-Shift-Enter not just Enter -- __________________________________ HTH Bob "sajith" wrote in message ... 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 -- Dave Peterson |
Extract
Share your formula.
sajith wrote: 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" wrote: 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 wrote: i got the result as 33 but its not true, i want the highest number only for the period of AUG "Bob Phillips" wrote: =MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200)) this is an array formula, so commit with Ctrl-Shift-Enter not just Enter -- __________________________________ HTH Bob "sajith" wrote in message ... 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 -- Dave Peterson -- Dave Peterson |
Extract
i was using bobs formula =MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200))
"Dave Peterson" wrote: Share your formula. sajith wrote: 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" wrote: 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 wrote: i got the result as 33 but its not true, i want the highest number only for the period of AUG "Bob Phillips" wrote: =MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200)) this is an array formula, so commit with Ctrl-Shift-Enter not just Enter -- __________________________________ HTH Bob "sajith" wrote in message ... 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 -- Dave Peterson -- Dave Peterson |
Extract
I would double check the data.
I think you have that value for Aug. sajith wrote: i was using bobs formula =MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200)) "Dave Peterson" wrote: Share your formula. sajith wrote: 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" wrote: 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 wrote: i got the result as 33 but its not true, i want the highest number only for the period of AUG "Bob Phillips" wrote: =MAX(IF(Sheet1!A2:A200="AUG",Sheet1!B2:B200)) this is an array formula, so commit with Ctrl-Shift-Enter not just Enter -- __________________________________ HTH Bob "sajith" wrote in message ... 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 -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| All times are GMT +1. The time now is 04:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com