CATEGORY: Lookup Formulas VERSIONS: All Microsoft Excel Versions

Problem: 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.

Rate this tip 1 2 3 4 5   RATING:   VIEWS: 5381 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Getting to Yes: Negotiating Agreement Without Giving In The Basics of Finance: Financial Tools for Non Financial Managers Marketing Plans Keys to Reading an Annual Report (Barron's Business Keys) Harry Potter and the Order of the Phoenix (Book 5) Windows XP for Dummies

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books