I am trying to Make one column of Required Certificates and then I have a column of tickets that are obtained. I would like to see a column that outlines the missing tickets that still need to be obtained
I was thinking:
=INDEX([Certificates Required]@row, MATCH([Certificates Obtained]@row, 0)) I just changed my columns around and now I get #NOMATCH
I dont know if it is possible
Help Article Resources
Check out the Formula Handbook template!