Z
z942849
SPREADSHEET HAS COLUMNS WITH DATA SPREAD OVER 12 MONTHS. IN THE 2ND TO LAST
COLUMN OF DATA, THERE IS TARGET THAT I WANT TO COMPARE TO EACH NUMBER IN THE
SAME ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I WANT
FORMULA IN THE LAST COLUMN TO PICK UP THE MONTH FROM THE TOP OF THE COLUMN
WHERE THE NUMBER IS GREATER THAN THE TARGET.
Example:
Jun Jul Aug Sep TARGET Exceeds Plan in Month of:
1,458 1,620 1,781 1,956 1,712 Aug
1,412 1,569 1,726 1,881 1,626 Aug
8 9 9 10 8 Jul
20 22 24 26 19 Jun
COLUMN OF DATA, THERE IS TARGET THAT I WANT TO COMPARE TO EACH NUMBER IN THE
SAME ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I WANT
FORMULA IN THE LAST COLUMN TO PICK UP THE MONTH FROM THE TOP OF THE COLUMN
WHERE THE NUMBER IS GREATER THAN THE TARGET.
Example:
Jun Jul Aug Sep TARGET Exceeds Plan in Month of:
1,458 1,620 1,781 1,956 1,712 Aug
1,412 1,569 1,726 1,881 1,626 Aug
8 9 9 10 8 Jul
20 22 24 26 19 Jun