Forum Discussion
lost customer tracking.
I have a database of clients who have been utilising the product of my business for the last three years. I'm interested in finding out which consumers are cancelling their subscriptions in a given month. how to use a formula to get that report in Excel.
1 Reply
=IFERROR(INDEX($A$2:$A$23,SMALL(IF(MONTH($B$2:$B$23)=$E$1,ROW($B$2:$B$23)-1),ROW(A1))),"")You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
