Return multiple matching results (as an array?)

  • Thread starter Thread starter Paul
  • Start date Start date
P

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
 
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
Click to expand...

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


--ron
 
Back
Top