Finding the First Value in a Row and Retrieving the Header for That Column

Problem:

Columns B:G contain the monthly payments for the first half of the year that were made for each investment in column A.
The payments for each investment may start or end on any of the months.
We want to retrieve the month on which payments for each investment started.
Solution:

Use the INDEX, MIN, IF, and COLUMN functions as shown in the following Array formula:

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.