I'm working on a staff leave sheet. If 'AL' or 'SL' appears in a cell, I want the formula to check the staff initials on the same row in column A against staff initials in the same column as the AL or SL leave comment. The answer should return how many matches there are.
Probably explained better in the attached example. Note, if adding multiple options such as 'AL' and 'SL' makes it complicated then another option could be if the cell contains any data.
Thanks for your help in advance.
Bookmarks