Hi,

I made a personnel tracker with on the left side column the names, on the first row the dates and then I fill in for everyday someone is working a 'W' and when they have a holiday I fill in an 'H'. The thing I want to do is to show only the rows that have one ore more 'H' behind the name and leave out the ones that don't have a planned holiday.

I tried adding an extra column with for each row a formula that returns 'Yes' when there is a row with an 'H' in it and 'No' if it doesn't so I can then add a filter to that column and show only the people with planned holidays. Sounds pretty easy but I can't figure out what formula I should use. I played with the LOOKUP function but so far no success...

Can anyone help me out here?