User Profile
FrenchyFri27
Copper Contributor
Joined Feb 01, 2023
User Widgets
Recent Discussions
Formula to Identify Winning Team by Team Name Over Different Days and Different Events
Hi All, Need help with this one. I'm trying to find the winning team that wins specific events on specific days based on LOWEST score. They should be identified by name (Team 1, Team 2, etc.. etc..) Example combination: Event 1, Day 1, Winner: Team 1. Zeros are considered did-not-qualify and should not be counted. It is possible to have ties but I'm not sure how to address this. In the sample size below I show 4 teams, however there are upwards of 20 teams and over 40 events over the course of the year. Each event is 3 days and each team's score must be counted separately, I cannot simply add the 3 days together to produce a value. Any help would be greatly appreciated ! Thanks.Issues Merging Two IF(AND) Formulas Together
Trying to a formula I have in two separate columns to function correctly under one column. Been trying for about an hour but haven't managed to figure it out. Formulas below: Column1: =IF(OR(ISNUMBER(SEARCH("Spare",K4)),ISNUMBER(SEARCH("Salvage",K4))),"Review","") Column2: =IF(AND(ISNUMBER(SEARCH("replace",K4)),I4<=0),"Review","") Any help or guidance would be greatly appreciated. THanks!
