I’m using the formula below to check for staff out of date with training (A8 being the staff name which is pasted if the criteria is met):
=IF(AND(Training_Records!N8>12,Training_Records!J8="y",Training_Records!D8=""),Training_Records!A8,"")
This generates a result in each row (some of which are blank as the criteria is not met ) and I now need to select only the cells with data in and paste into a separate sheet, ignoring the blank cells and without gaps.
Please can someone help
=IF(AND(Training_Records!N8>12,Training_Records!J8="y",Training_Records!D8=""),Training_Records!A8,"")
This generates a result in each row (some of which are blank as the criteria is not met ) and I now need to select only the cells with data in and paste into a separate sheet, ignoring the blank cells and without gaps.
Please can someone help