Sep 24 2022 03:44 PM
Hi all,
I tried to work this out myself, but it was very labor intensive and not very tidy. For some reason, the formulas wouldn't spill!
i have a list of names, that appear in several arrays on one spreadsheet. these names have results in the same row that i need.
I want to collect these results and tally them next to the same name on a new spreadsheet.
On top of that the names need to ordered according the results tally from highest to lowest.
i have done all this except for the ordering from highest to lowest in the screenshots below
i actually only need to show the info in columns A and B.
Hope i have explained myself clearly enough.
Cheers Richard.
Sep 24 2022 04:16 PM
Sep 24 2022 07:43 PM
Sep 24 2022 09:56 PM
Sep 26 2022 07:31 PM
Sep 26 2022 07:32 PM
Sep 27 2022 07:43 AM
SolutionCan you check whether the following formula in cell B3 brings the desired result? If not, I may have misunderstood something.
=INDEX(XLOOKUP(A3:A22,'Competition results'!K3:K100,'Competition results'!O3:O100),ROW(1:20))+INDEX(XLOOKUP(A3:A22,'Competition results'!V1:V98,'Competition results'!Y1:Y98),ROW(1:20))
Excel Insider or Excel for the Web can also use the following formula:
=BYROW(HSTACK(XLOOKUP(A3:A22,'Competition results'!K3:K100,'Competition results'!O3:O100),XLOOKUP(A3:A22,'Competition results'!V1:V98,'Competition results'!Y1:Y98)),LAMBDA(in,SUM(in)))
Sep 27 2022 04:53 PM
Sep 27 2022 07:43 AM
SolutionCan you check whether the following formula in cell B3 brings the desired result? If not, I may have misunderstood something.
=INDEX(XLOOKUP(A3:A22,'Competition results'!K3:K100,'Competition results'!O3:O100),ROW(1:20))+INDEX(XLOOKUP(A3:A22,'Competition results'!V1:V98,'Competition results'!Y1:Y98),ROW(1:20))
Excel Insider or Excel for the Web can also use the following formula:
=BYROW(HSTACK(XLOOKUP(A3:A22,'Competition results'!K3:K100,'Competition results'!O3:O100),XLOOKUP(A3:A22,'Competition results'!V1:V98,'Competition results'!Y1:Y98)),LAMBDA(in,SUM(in)))