Extracting data from a master list

[jdhfch]

Hi,

Please can I ask for help?

I am wanting to extract all data from a list and create a new list of data using a criteria. If you look at the list below, I am wanting to extract all data related to account 125 (or whatever would be in cell A1) and put it into cell A17 down. The data may not be all together, eg some may be on lines 9,10,11,12 etc, and some may be further down. I don't want any gaps? I know I can use a filter, but I need to do it using a formula if possible?

 

[Fluff]

How about

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$4:$A$14)/($A$4:$A$14=$A$1),ROWS(A$14:A17))),"")

 

[jdhfch]

How about

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$4:$A$14)/($A$4:$A$14=$A$1),ROWS(A$14:A17))),"")

Thank you Fluff.. That gets the account number data, how do i get the other columns as well please?

 

[jdhfch]

Thank you Fluff.. That gets the account number data, how do i get the other columns as well please?

Ignore me.... I got it, thank you

 

[Fluff]

You're welcome & thanks for the feedback.