Hi Everyone,

I've got a brain cruncher here for you if you please

I am using a matrix to track personnel movements. Dates across the top, names down the left hand side. The values in in the matrix correspond to where someone is e.g. 1=Office, 2=Field, 3=Home

See picture below

Data.png

It works well for tracking the locations of a large team however i am looking to make some summary tables to show a list of names as to who is, for example, in the office TODAY.
So i need something that will look across the top to find todays date then go down and list all the names that have a "1" entry

I have been googling and playing with complex array formulas which are way outside my knowledge

Hope someone can help. Reply if you need more information