Excel trick for reading tables? [Closed]
Hello,
I'm using Microsoft Excel. Imagine I have a table with two columns, one labelled "Staff Name" and one labelled "Able to lock-up."
The first column consists of names such as Tom, Dick, Harry etc. The second columns is simply like Yes, No, No, Yes, Yes etc denoting whether the respective staff name can lock-up.
That's that. Now I want to create a third, separate list, that simply lists the staff that are able to do lock-up. This is to use in like a separate rota worksheet via the data validation tool so that it only lets the me (the end-user) to only select staff able to do lock-up. I'm assuming creating the third table would be the solution, or perhaps Data Validation tool is versatile for this via custom?
Anyway, I was playing around, creating a third list using the function in a later column but same row as the staff name = if(C1="YES",B1,"") so that if they are able to lock-up it displays the staff name and if not, leave it blank. This works, but the data validation in-cell drop box includes the blanks cells and looks ugly, and I don't like ugly things.
Any suggestions?