» Retrieving the Column Header of the Next Non-Blank Cell in a Row
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Row 2 lists amounts payable over a twelve month period.
A blank cell in the row indicates that no payment is due that month.
We want to create a new row that, for each month, will display the name of the month in which the next payment is due.
Solution:
Use the INDEX, MATCH, MIN, IF, and COLUMN functions as shown in the following Array formula:
{=INDEX(C1:M1,MATCH(MIN(IF(C2:M2<>" ",COLUMN(C2:M2))),COLUMN(C2:M2)))}
Enter the formula in cell B3 and copy/paste it across the row from cell B3 up to cell M3.
Book Store:
Recommended Books:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Writing Excel Macros with VBA, 2nd Edition
- Investing for Dummies, Third Edition
- Personal Finance for Dummies
No comments have been submitted.

