I have a table with several columns with values that represent total votes obtained by political parties. I need a script that finds the greatest values of these columns and obtains the name of the column, i.e. the political party.
Thanks in advance for your help.
The Match() function is under the Conditionals section of the Formula Editor.
With the Maximum() funtion built and selected in the Editor, click on Conditionals -> Match. You'll be prompted about adding arguments, select "Do Not Add".
Then click on the ^ button in the toolbar to add the four pairs of arguments and then fill them in.