Forum Discussion
Using Index/Match to return a list of clients who are active between 2 dates
I have a list of all of the clients I see throughout the year. From that data, I am trying to return a list of clients who are active between 2 dates (any given month) For context, I'm using 2 sh...
=IFERROR(INDEX(Cts!$A$2:$A$10,SMALL(IF((Cts!$G$2:$G$10<='M1'!$H$2)*(Cts!$H$2:$H$10>='M1'!$G$2),ROW(Cts!$A$2:$A$10)-1),ROW(Cts!B1))),"")You can try this formula in cell A2 of sheet "M1". Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021. Fill the formula down as required.
Sheet "Cts":
Sheet "M1":