Hello everyone,

I have an array formula that works great and gives me the resulting list that I need. However, I would like to sort this list alphabetically so that the users who view the report do not have to search for their name (I could very easily filter the list so they could select their name - but even this is very problematic for them). The formula I currently have is:

{=IFERROR(IFERROR(IFERROR(IFERROR(INDEX('BF Beginning'!$W$2:$W$500,MATCH(ROWS(A$1:$A1)-1,COUNTIF($A$1:A1,'BF Beginning'!$W$2:$W$500)+('BF Beginning'!$W$2:$W$500=""),0)),INDEX(New!$X$2:$X$500,MATCH(0,COUNTIF($A$1:A1,New!$X$2:$X$500)+(New!$X$2:$X$500=""),0))),INDEX('Closed or Transferred'!$Z$2:$Z$483,MATCH(0,COUNTIF($A$1:A1,'Closed or Transferred'!$Z$2:$Z$483)+('Closed or Transferred'!$Z$2:$Z$483=""),0))),INDEX('BF End'!$W$2:$W$498,MATCH(0,COUNTIF($A$1:A1,'BF End'!$W$2:$W$498)+('BF End'!$W$2:$W$498=""),0))),"")}

I saw a formula in my search efforts that had a different "Match" block but I can't get it to work at the moment. The new formula was changed to:

{=IFERROR(IFERROR(IFERROR(IFERROR(INDEX('BF Beginning'!$W$2:$W$500,MATCH(ROWS($A$1:A1)-1,COUNTIF($A$1:A1,'BF Beginning'!$W$2:$W$500)+('BF Beginning'!$W$2:$W$500=""),0)),INDEX(New!$X$2:$X$500,MATCH(ROWS($A$1:A1)-1,COUNTIF($A$1:A1,New!$X$2:$X$500)+(New!$X$2:$X$500=""),0))),INDEX('Closed or Transferred'!$Z$2:$Z$500,MATCH(ROWS($A$1:A1)-1,COUNTIF($A$1:A1,'Closed or Transferred'!$Z$2:$Z$500)+('Closed or Transferred'!$Z$2:$Z$500=""),0))),INDEX('BF End'!$W$2:$W$500,MATCH(ROWS($A$1:A1)-1,COUNTIF($A$1:A1,'BF End'!$W$2:$W$500)+('BF End'!$W$2:$W$500=""),0))),"")}

Any suggestions?

Thanks!