Hello,
I have the attached spreadsheet. It is used for attendance. People color code the cells when someone is not available, different colors mean different things.
With the help of this form I managed to come up with a formula that checks each cell to see if it is white, and if it is it sums it. I now get a total number of People working based on how many white cells there are in the range for that day. Brilliant!
I now want to take it one step further, if possible. I would like to be able to make a LIST OF NAMES of who is working each day. So I need to be able to search by date, for white colored cells, and then populate the name based on date / white cell.
Is this possible?
Thanks,
Todd
Bookmarks