How to return the first value in a range of values that equals a specific condition
I am trying to develop a formula to display when the last billing was sent based on a series of rows that show the amount that was billed for a specific month.
I have two columns: Billing Month and Billing Amount
I would like the formula to return the last month, in a list of Months (Jan-Dec), where the billing amount is greater than 0.
Billing Month Billing Amount
My hope is to have the formula return the very last month that has been billed. In this case May.
Is this even possible?
Help Article Resources
Check out the Formula Handbook template!