find non-blank cells and return line with only specific text

Hi All,
I'm trying to work out how to get the attached spreadsheet to only show the names of those staff who are available on a certain day between certain timeframes.
The data is generated to an array (W20-W114) which puts a "Y", "N", "B" or "0" into any 2 or more (up to 17) adjacent cells next to the staff member's name.
I'm trying to get the names of only those staff who have "Y" next to their name in the array, but in ALL the non-blank cells. If there is one or more cells with N,B or 0 then I want the resultant list to ignore that staff member.
In the attachment, I have included the result I'd like in column G.

Regards,
Greg

Hi Marvin,
Unfortunately columns W thru to AN are not static values but variables linked to other pages (which I couldn't attach due to attachment file size limits).
They change depending on the values in B6, C6, D6 & F6.
So I'm pretty sure I need some VBA code to provide me with the selective array I require.
Thanks for your help though.

Hi Marvin,
I managed to get the solution using the follwing code (provided by a colleague who noticed my troubles):

Sub available()
Dim rng As Range
Dim col As Integer
Dim row As Variant
Dim person As String
Dim flag As Boolean
Dim x As Integer
Dim y As Integer
Set rng = Range("Availables")
x = ActiveCell.Column
'y = ActiveCell.row
For Each row In rng.Rows
person = row.Cells(1, 1)
If person = "-" Then
Exit Sub
End If
flag = False
For col = 2 To rng.Columns.Count
If row.Cells(1, col) <> "Y" And row.Cells(1, col) <> "" Then
flag = True
End If
Next
If flag = False Then
y = ActiveCell.row
Cells(y, x).Value = person
Cells(y + 1, x).Select
End If
Next

End Sub

Thanks for your assistance