View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GeoH GeoH is offline
external usenet poster
 
Posts: 1
Default How to extract list of persons available from an availability list

Using Excel I have prepared a table listing in column A fixture dates of
matches and in row 1 a list of persons and and inserted "y" in appropriate
name column their availability for certain fixtures. How can I easily extract
a list of persons available on a certain date i.e. where there is a "y" in
their name column in a fixture date row