Hi there,
I am trying to make a spreadsheet in which I need to be able to return multiple values corresponding to the same dates without repeating the first returned value again (If that makes sense!!). For example:
A (birthdates) B(people)
1 2/04/2012 Ash
2 3/04/2012 San
3 2/04/2012 Ong
4 5/04/2012 Joe
5 6/04/2012 Raj
6 2/04/2012 Sur
7 8/04/2012 Ryan

Say for example, out of the list I want to return all of the people with a birthday on the 2/04/2012. I can make a formula like:
'=VLOOKUP(A10,B2:C8, 2, FALSE)', where the cell range is B2:C8, A10 is the date (i.e. 2/04/2012) and the dates are located in column 2. It will return 'Ash' as having a birthday on the required date (which is great). However, I want to make a formula for the cell below this to give me the next person having a birthday on the 2/04/2012 (i.e. Ong), but not return 'Ash' again. And continue this process below Ong (i.e. Return Sur but not Ong or Ash).

I hope that makes sense and someone is able to help me out. I have been thinking about it for a while now, but I'm not super talented when it comes to excel forumlae!
Thanks