medium10 pts · first answer countsexceldynamic-arrays

Sort names by a column you do not show

You want a list of employee names (A2:A200) sorted by joining date (C2:C200), oldest first, without showing the dates. Which formula does it?

A.=SORTBY(A2:A200,C2:C200,1)B.=SORT(A2:A200,C2:C200,1)C.=SORT(A2:A200,3,1)D.=SORTBY(C2:C200,A2:A200,1)

Discussion 0

Join free to post in the discussion.