Or tryBYROW and LAMBDA should be available to all EXCEL 365 usersFormula:![]()
=BYROW(A2:K12,LAMBDA(r,INDEX(SORTBY(A1:K1,r,-1),1)))
Or tryBYROW and LAMBDA should be available to all EXCEL 365 usersFormula:![]()
=BYROW(A2:K12,LAMBDA(r,INDEX(SORTBY(A1:K1,r,-1),1)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks