Sorting with Unique but not sorting header row

[Peter Davison]

I am using the unique formula below and want to sort where the match finds a "Y" in a column in row 9 (MATCH("Y",$F$9:$AZ$9,0)
However I need to bring the headers from Row 7 in as part of the array, but I want it to sort only from Row 8 and cannot work out how to do this using Unique?

=SORT(UNIQUE(FILTER(Stores!$A$7:$AZ$4998,{1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0})),MATCH("Y",$F$9:$AZ$9,0))

Any help would be appreciated.

 

[Fluff]

How about

=VSTACK(Stores!A7:D7,SORT(UNIQUE(Stores!A8:D4998),MATCH("Y",F9:I9,0)))

 

[Peter Davison]

Thank you very much, that worked spot on.
Appreciate your help

 

[Fluff]

You're welcome & thanks for the feedback.