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 m...
=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.