I have a spreadsheet with months listed chronologically across columns and customers listed down the rows.
Customer Month1 Month2 Month3 Most Recent Month Purchased
ABC
BCD
CDE
I would like to put a formula in the Most Recent Month Purchased that will give me the date of the last month that a customer made a purchase.
In the example Above is Customer ABC purchased in Month 1 and Month 2 but not Month 3 I would like the answer to show Month 2.
I thought of using a Nested If statement but I have 48 months of data and it would be a very unwieldy formula.
Any suggestions would be most appreciated
Customer Month1 Month2 Month3 Most Recent Month Purchased
ABC
BCD
CDE
I would like to put a formula in the Most Recent Month Purchased that will give me the date of the last month that a customer made a purchase.
In the example Above is Customer ABC purchased in Month 1 and Month 2 but not Month 3 I would like the answer to show Month 2.
I thought of using a Nested If statement but I have 48 months of data and it would be a very unwieldy formula.
Any suggestions would be most appreciated