I've got a new problem I need to figure out but can't quite do it.
Now I'm trying to calculate the highest score for a player. Here is an
Screenshot 2023-11-25 221209.jpg
Here is the code
Column N
Now the issue is, I need to have the * next to the high score if they player was Not Out (column H =1)Code:=IF(AND(MAXIFS($C$2:C2,$A$2:A2,A2)=C2,H2=1),MAXIFS($C$2:C2,$A$2:A2,A2)&"*",MAXIFS($C$2:C2,$A$2:A2,A2))
ODI Bat.xlsx




Reply With Quote
Bookmarks