Not sure if this is possible so just want to throw the question out to you guys.

If I've got masses of data in say sheet1, could I in sheet2 use any kind of formula that would display every row of sheet1 where that meets a condition.

i.e...


In Cell A1 of Sheet2 :

IF('Sheet1'A1=1, **DISPLAY HOLE ROW**)

This could result in high number of matches for what I'm trying to do but is there any way that Excel could display all of these in rows B2:B*HOWEVER MANY MATCHES**



Thoughts?

Cheers.