Hi,

I hope someone can help me with this. Here is an example of my spreadsheet:

A B C D
1 01/07/2012 02/07/2012 03/07/2012
2 NAME
3 John H H
4 Gary H
5 Paul H H


Now what I would want to do is to be able to create a list of names for a given date where there is a H in the date cell, for example if my date was 02/07/2012 then the list will give me John and Gary and if the date was 03/07/2012 then it would only give me Paul.

I hope this makes sense.

Thanks in advance for any help.

Z