| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract 7 and 30 day max | Excel Discussion (Misc queries) | |||
| extract name | Excel Discussion (Misc queries) | |||
| How can I extract each Max key value ? | New Users to Excel | |||
| Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
| Last Name, First Name extract | Excel Discussion (Misc queries) | |||
Linear Mode
