Please could any one suggest the function I should use to resolve the following issue - With this I will be able to investigate further / get this working for our user.
Requirement: The user would like a lookup of a cell range to be displayed in another tab. We only want cells that have not been filled in with a colour to come across (no fill) or if the cell is blank / has no text in it.
Column A = Staff members name. Column B = AM time that staff member has checked in. Column C = PM time that staff member is checking out.
If an AM or PM time has not being given the cell will be red.
I would like to display a list of all users where the AM time has been filled out, but the PM time has not been filled in yet.
In the example below, Person A would not need to be brought into the new tab as we have AM and PM checked in / out times. However Person B and C would be brought in.
Please let me know if you need nay further information.