Forum Discussion
anna_1270
Mar 22, 2023Copper Contributor
Formula Help
Hi just need help with to find a formula used in cell B3 that would uses MAX and IF formula to find the highest overall mark (column E) among players (Column B) for each football club (column g)
appreciate any help!
1 Reply
Sort By
- OliverScheurichGold Contributor
=MAX(IF(Tabelle1[club]=$B$2,Tabelle1[overall]))
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.