Forum Discussion

zackwilson11's avatar
zackwilson11
Copper Contributor
Mar 18, 2022
Solved

Excel - Help with "Tiebreaker"

Hello,

 

I am working on creating a spreadsheet that can be used to analyze data to show which teams are performing the best. I have run into a stump, that I can't figure out and am looking for some support. 

 

Here's my situation - a team potentially can work the same flight, compartment in the same week or month. This is leading Xlookup to only see the first flight information which is creating errors in the rest of the calculations. I'm using FILTER to get the flights, but can't figure out how to get the corresponding date without relaying another piece of data.  Below is showing how my formulas are currently working, but the highlighted value should have different times.  https://1drv.ms/x/s!ApwNjcg8Ua7KhatqlNpN8n_MdR0umg?e=ENKgxt 

Resources