|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 22nd, 2008, 08:56 AM
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
September 22nd, 2008, 10:12 AM
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
September 22nd, 2008, 12:41 PM
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
September 22nd, 2008, 01:03 PM
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
September 22nd, 2008, 03:36 PM
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
September 22nd, 2008, 05:34 PM
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
September 23rd, 2008, 04:54 AM
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
September 23rd, 2008, 01:53 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
