Looking for formula (non-array preferred and ignoring blanks) to look into sheet named Okay, sort column A and column B alphabetically and extract values in this sheet (column A:K of sheet named Okay) into column A to column K of sheet named Here_1. Desired outcome is in sheet named Here_1 in column A to column K.
This formula
=IFERROR(INDEX(Okay!$A$1:$A$40,MOD(AGGREGATE(15,6,COUNTIFS(Okay!$A$2:$A$40,"<"&Okay!$A$2:$A$40)*10^6+ROW(Okay!$A$2:$A$40)/(Okay!$A$2:$A$40<>""),ROWS(A$2:A2)),10^6)),"")
works for column A extraction in sheet named Here_1, but cannot get it to work for column B:K in sheet named Here_1.
See attached sample file.
Formula should ignore blanks (non-array preferred).
Thanks.
Bookmarks