Forum Discussion
Correct Excel Function
I am trying to use a function that will display the company name with the largest spend for each different employee.
=INDEX($A$2:$A$26,MATCH(1,(LARGE(IF(F2=$B$2:$B$26,$C$2:$C$26),1)=$C$2:$C$26)*($B$2:$B$26=F2),0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.