Hi there! I'm building a certification training tracker that essentially tracks the name of people, the certificates they've completed, and the expiry date of the certification.
I'm trying to figure out a formula that will return the name of a person if they have completed AT LEAST 4 training certifications that HAVE NOT expired (for reference ,red means that they will expire in less than 1 month, green means they will expire in more than one month, and orange highlights mean that they have already expired)
the formula I could come up with so far is : =IFERROR(INDEX($A$4:$A$12,SMALL(IF(B4:L12>TODAY(),ROW($B$4:$B$12)-ROW($B$4:$L$12)+1),ROWS($B$4:$L$12))),"") --> but this did not give me the right names
THANK YOU SO MUCH FOR YOUR HELP!!!!
Bookmarks