| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT
SPREADSHEET HAS COLUMNS WITH DATA SPREAD OVER 12 MONTHS. IN THE 2ND TO LAST
COLUMN OF DATA, THERE IS NUMBER THAT I WANT TO COMPARE TO EACH NUMBER IN THE SAME ROW ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I WANT FORMULA I NTHE LAST COLUMN TO PICK UP THE MONTH AT THE TOP OF THE COLUMN WHERE THE NUMBER IS GREATER. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT
What if there's more than one number in the row that's greater?
-- Biff Microsoft Excel MVP "z942849" wrote in message ... SPREADSHEET HAS COLUMNS WITH DATA SPREAD OVER 12 MONTHS. IN THE 2ND TO LAST COLUMN OF DATA, THERE IS NUMBER THAT I WANT TO COMPARE TO EACH NUMBER IN THE SAME ROW ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I WANT FORMULA I NTHE LAST COLUMN TO PICK UP THE MONTH AT THE TOP OF THE COLUMN WHERE THE NUMBER IS GREATER. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN
i WANT IT TO PICK UP THE FIRST MONTH WHEN IT IS GREATER.
"T. Valko" wrote: What if there's more than one number in the row that's greater? -- Biff Microsoft Excel MVP "z942849" wrote in message ... SPREADSHEET HAS COLUMNS WITH DATA SPREAD OVER 12 MONTHS. IN THE 2ND TO LAST COLUMN OF DATA, THERE IS NUMBER THAT I WANT TO COMPARE TO EACH NUMBER IN THE SAME ROW ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I WANT FORMULA I NTHE LAST COLUMN TO PICK UP THE MONTH AT THE TOP OF THE COLUMN WHERE THE NUMBER IS GREATER. . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN
SEE THE EXAMPLE IN THE POST I ADDED AT 9:13 PM
"T. Valko" wrote: What if there's more than one number in the row that's greater? -- Biff Microsoft Excel MVP "z942849" wrote in message ... SPREADSHEET HAS COLUMNS WITH DATA SPREAD OVER 12 MONTHS. IN THE 2ND TO LAST COLUMN OF DATA, THERE IS NUMBER THAT I WANT TO COMPARE TO EACH NUMBER IN THE SAME ROW ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I WANT FORMULA I NTHE LAST COLUMN TO PICK UP THE MONTH AT THE TOP OF THE COLUMN WHERE THE NUMBER IS GREATER. . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN
JUST NOTICED THE LAST COLUMN TITLE "EXCEEDS PLAN IN MONTH OF" GOT SKEWED.
"T. Valko" wrote: What if there's more than one number in the row that's greater? -- Biff Microsoft Excel MVP "z942849" wrote in message ... SPREADSHEET HAS COLUMNS WITH DATA SPREAD OVER 12 MONTHS. IN THE 2ND TO LAST COLUMN OF DATA, THERE IS NUMBER THAT I WANT TO COMPARE TO EACH NUMBER IN THE SAME ROW ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I WANT FORMULA I NTHE LAST COLUMN TO PICK UP THE MONTH AT THE TOP OF THE COLUMN WHERE THE NUMBER IS GREATER. . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN
see your later post
-- Biff Microsoft Excel MVP "z942849" wrote in message ... SEE THE EXAMPLE IN THE POST I ADDED AT 9:13 PM "T. Valko" wrote: What if there's more than one number in the row that's greater? -- Biff Microsoft Excel MVP "z942849" wrote in message ... SPREADSHEET HAS COLUMNS WITH DATA SPREAD OVER 12 MONTHS. IN THE 2ND TO LAST COLUMN OF DATA, THERE IS NUMBER THAT I WANT TO COMPARE TO EACH NUMBER IN THE SAME ROW ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I WANT FORMULA I NTHE LAST COLUMN TO PICK UP THE MONTH AT THE TOP OF THE COLUMN WHERE THE NUMBER IS GREATER. . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN
Please get your caps lock key repaired so that you can stop SHOUTING.
-- David Biddulph "z942849" wrote in message ... i WANT IT TO PICK UP THE FIRST MONTH WHEN IT IS GREATER. "T. Valko" wrote: What if there's more than one number in the row that's greater? -- Biff Microsoft Excel MVP "z942849" wrote in message ... SPREADSHEET HAS COLUMNS WITH DATA SPREAD OVER 12 MONTHS. IN THE 2ND TO LAST COLUMN OF DATA, THERE IS NUMBER THAT I WANT TO COMPARE TO EACH NUMBER IN THE SAME ROW ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I WANT FORMULA I NTHE LAST COLUMN TO PICK UP THE MONTH AT THE TOP OF THE COLUMN WHERE THE NUMBER IS GREATER. . |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN
This worked. Thank you!
"T. Valko" wrote: see your later post -- Biff Microsoft Excel MVP "z942849" wrote in message ... SEE THE EXAMPLE IN THE POST I ADDED AT 9:13 PM "T. Valko" wrote: What if there's more than one number in the row that's greater? -- Biff Microsoft Excel MVP "z942849" wrote in message ... SPREADSHEET HAS COLUMNS WITH DATA SPREAD OVER 12 MONTHS. IN THE 2ND TO LAST COLUMN OF DATA, THERE IS NUMBER THAT I WANT TO COMPARE TO EACH NUMBER IN THE SAME ROW ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I WANT FORMULA I NTHE LAST COLUMN TO PICK UP THE MONTH AT THE TOP OF THE COLUMN WHERE THE NUMBER IS GREATER. . . |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN
Oops - sorry!
"David Biddulph" wrote: Please get your caps lock key repaired so that you can stop SHOUTING. -- David Biddulph "z942849" wrote in message ... i WANT IT TO PICK UP THE FIRST MONTH WHEN IT IS GREATER. "T. Valko" wrote: What if there's more than one number in the row that's greater? -- Biff Microsoft Excel MVP "z942849" wrote in message ... SPREADSHEET HAS COLUMNS WITH DATA SPREAD OVER 12 MONTHS. IN THE 2ND TO LAST COLUMN OF DATA, THERE IS NUMBER THAT I WANT TO COMPARE TO EACH NUMBER IN THE SAME ROW ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I WANT FORMULA I NTHE LAST COLUMN TO PICK UP THE MONTH AT THE TOP OF THE COLUMN WHERE THE NUMBER IS GREATER. . . |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "z942849" wrote in message ... This worked. Thank you! "T. Valko" wrote: see your later post -- Biff Microsoft Excel MVP "z942849" wrote in message ... SEE THE EXAMPLE IN THE POST I ADDED AT 9:13 PM "T. Valko" wrote: What if there's more than one number in the row that's greater? -- Biff Microsoft Excel MVP "z942849" wrote in message ... SPREADSHEET HAS COLUMNS WITH DATA SPREAD OVER 12 MONTHS. IN THE 2ND TO LAST COLUMN OF DATA, THERE IS NUMBER THAT I WANT TO COMPARE TO EACH NUMBER IN THE SAME ROW ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I WANT FORMULA I NTHE LAST COLUMN TO PICK UP THE MONTH AT THE TOP OF THE COLUMN WHERE THE NUMBER IS GREATER. . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT | Excel Discussion (Misc queries) | |||
| Formula w/two columns to add the greater number | Excel Worksheet Functions | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| Formula for number of entries in colum that are greater than 2 hr | New Users to Excel | |||
| Way of making an object with a greater number be given a point.... | Excel Discussion (Misc queries) | |||
Linear Mode
