I have the formula below working(Thanks to J. Topley for all his help),
=IF(COUNTIFS(ATMS!B:B,$G27,ATMS!H:H,"G557",ATMS!J:J,"C",ATMS!L:L,"="&"<60"),"<60",IF(COUNTIFS(ATMS!B:B,G27,ATMS!H:H,"G557",ATMS!J:J,"C"),"C",""))
What I would like to do, in a separate area of worksheet 1(Quals tab, highlighted in Yellow) is list the upcoming training, displayed on worksheet 2 for our employees. I would like to list the info contained in columns M(event start date/time) and N(bldg and classroom location). I have provided an uppdated sample.
Thanks.
Bookmarks