Returning a value that hasn't already been found

[azlan270690]

Hi there,
I am trying to make a spreadsheet in which I need to be able to retur
multiple values corresponding to the same dates without repeating th
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 wit
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 i
the date (i.e. 2/04/2012) and the dates are located in column 2. It wil
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 th
next person having a birthday on the 2/04/2012 (i.e. Ong), but no
return 'Ash' again. And continue this process below Ong (i.e. Return Su
but not Ong or Ash).

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

 

[azlan270690]

Thanks for your help Ron. Yeah unfortunately I am unable to use a filte
function for the particular spreadsheet I am using. But the formula wa
exactly what I was after. Thanks again

 

[Ron Rosenfeld]

Thanks for your help Ron. Yeah unfortunately I am unable to use a filter
function for the particular spreadsheet I am using. But the formula was
exactly what I was after. Thanks again.

Glad to help. Thanks for the feedback.