The formula I am using is
=IFERROR(INDEX(Data!A:A & " " & Data!B:B,SMALL(IF(Data!$E$1:$E$100="SP",IF(Data!$F$1:$F$100="Ready for Advancement",ROW($A$1:$A$100),""),""),ROW(A1))),"")
What I'm trying to do is have the first part Data!A:A align to the left and Data!B:B align to the right. I can't think of any way to do this other than using spaces like " ". The problem is I don't want to have to adjust the amount of spaces for every cell manually.
I have attached an example excel sheet and hope someone can help me.
Thank you all!
Bookmarks