Return multiple matching results (as an array?)

[Paul]

I want to have returned all the items matching a criteria
selection ie.

A B C
1 Y DataA
2 Y DataB
3 N DataC
4 Y DataD
5 N DataE
6 Y DataF

I would want both Data3, Data5 returned for criteria
= "N".
Is there an Excel function to do this?
Thanks in anticipation
Paul

 

[Frank Kabel]

Hi
you may try downloadind Alan Beban's array functions
(http://home.pacbell.net/beban)
They'll include a function called VLOOKUPS (for returning
multiple
lookup results)

 

[Ron Rosenfeld]

I want to have returned all the items matching a criteria
selection ie.

A B C
1 Y DataA
2 Y DataB
3 N DataC
4 Y DataD
5 N DataE
6 Y DataF

I would want both Data3, Data5 returned for criteria
= "N".
Is there an Excel function to do this?
Thanks in anticipation
Paul

You might also look at Data/Auto Filter and/or Data/PivotTable


--ron