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.

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.

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.


.

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.


.

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.


.

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.


.

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.


.

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.


.



.

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.


.



.

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.


.



.