SORT formula Alphabetically based on order of ARRAY?

[thewiseguy]

Hello all. Here is my current formula:

=SORT(UNIQUE(VSTACK(Input!$R$4:$R$503,Input!$W$4:$W$503,Input!$Y$4:$Y$503,Input!$AA$4:$AA$503,Input!$AC$4:$AC$503,Input!$AE$4:$AE$503,Input!$AG$4:$AG$503,Input!$AI$4:$AI$503)))

I am hoping to find a way to populate the data, by order of the array in which they are being selected from. so in this case:

column R
column W
column Y
column AA
column AC
column AE
column AG
column AI

 

[Fluff]

Sounds like you just want to remove the sort function.

 

[thewiseguy]

Sounds like you just want to remove the sort function.

that worked perfectly, thank you.

is there a way to alphabetize the data within each array?

 

[Fluff]

You would need to sort each range individually inside the vstack.

 

[thewiseguy]

You would need to sort each range individually inside the vstack.

sort function in front of each one?

 

[Fluff]

That's right.

 

[thewiseguy]

That's right.

I had to change the formula to this:

=LET(u,UNIQUE(VSTACK(Input!$R$4:$R$503,Input!$W$4:$W$503,Input!$Y$4:$Y$503,Input!$AA$4:$AA$503,Input!$AC$4:$AC$503,Input!$AE$4:$AE$503,Input!$AG$4:$AG$503,Input!$AI$4:$AI$503)),FILTER(u,u<>""))

can you show me how to include the SORT function?

 

[Fluff]

Like

=LET(u,UNIQUE(VSTACK(SORT(Input!$R$4:$R$503),SORT(Input!$W$4:$W$503),Input!$Y$4:$Y$503,Input!$AA$4:$AA$503,Input!$AC$4:$AC$503,Input!$AE$4:$AE$503,Input!$AG$4:$AG$503,Input!$AI$4:$AI$503)),FILTER(u,u<>""))

 

[thewiseguy]

Like

=LET(u,UNIQUE(VSTACK(SORT(Input!$R$4:$R$503),SORT(Input!$W$4:$W$503),Input!$Y$4:$Y$503,Input!$AA$4:$AA$503,Input!$AC$4:$AC$503,Input!$AE$4:$AE$503,Input!$AG$4:$AG$503,Input!$AI$4:$AI$503)),FILTER(u,u<>""))

THANK YOU!

 

[Fluff]

You're welcome & thanks for the feedback.