For M$ Excel, I was given the following macro code a couple years ago. I no longer have access to Excel and am now using LibreOffice. But, my spreadsheet page with the code just says #MACRO? when it should display the top three (3) point earners and their respective total points. In the attached screenshot, it should return the following:
1ST William 25
2ND Andrew 20
3RD Brian 20
The original Excel macro code I was given is:
=TAKE(SORT(HSTACK(UNIQUE($J$2:$J$27),SUMIF($J$2:$J$27,UNIQUE($J$2:$J$27),$K$2:$K$27)),2,-1),3)
When I open the .xls file in LibreOffice, the code has the following:
{=_xlfn.TAKE(_xlfn._xlws.SORT(_xlfn.HSTACK(_xlfn.UNIQUE($J$2:$J$27),SUMIF($J$2:$J$27,_xlfn.UNIQUE($J$2:$J$27),$K$2:$K$27)),2,-1),3)}
I am not proficient in spreadsheets. And I’m in a bit of a time crunch so I can’t just go teach myself macros etc. I can’t even edit it because it tells me “You cannot change only part of an array.” I have no idea how to edit this … or re-create it … etc. I don’t even know which cells to grab to do any of these things. Ugh. I feel stupid. Can anyone just knock it out for me … and tell me exactly what I need to do?
