I have a customer revenue file that shows revenue by month and projected increases. I'm looking for a formula to identify what month the customer's revenue increases.
So if Customer "Brown" has no revenue, but in October 2020, starts showing revenue, the formula will indicate that revenue started in October 2020.
I want to use the first month column as the basis for determining when the amount increases.
Bookmarks