Return a list based on a search.

[dsc1014]

I am trying to display a list of names based on what quarter they were last seen. I have a sample of what I am talking about attached. I have looked through the threads and tried many different ways but have thus far been unsuccessfull. Any help you can give would be appreciated.

Thanks

[oeldere]

maby sorting the data.

excel 2007

Data => sort => sort on column A
Data => sort => sort on column B

See the attached file.

[Haseeb Avarakkan]

Try this Array Formula in F2, with CTRL+SHIFT+ENTER

=IFERROR(INDEX($B:$B,SMALL(IF($A$2:$A$12=COLUMNS($F2:F2),ROW($B$2:$B$12)),ROWS(F$2:F2))),"")

Then copy down & across.

[dsc1014]

Haseeb A,

Thank you. That worked perfectly. I had been trying a lot of very complicated examples but this was able to do exactly what I wanted.