SOLVED

Tracker Ranking Trouble

New Contributor

Hi! I'm kind of new to excel and excel functions, so I was hoping I might be able to get help here. I have a worksheet currently that tracks different cardio exercises, their duration, their distance, calories, speed, and heart rate.

I wanted to set up a function that would rank them (ie. fastest speed) and on which date that happened, and I figured out how to tell it to give me the date in which I walked the fastest:

 

 

 

=XLOOKUP(LARGE(D:D,1),D:D,B:B)

 

 

 

However I forgot to tell it which cardio exercise as well as which month the ranking should be done in. I thought it might be:

 

 

 

=ifs(XLOOKUP(LARGE(D:D,1),D:D,B:B),A:A,K2,C:C,K3)

 

 

 

 I though this might work, because I set up a few other cells similar to this (ie. in cell L3), but unfortunately it did not.

I'm not even sure this is possible but, I would love to hear your thoughts and ideas.

If I can/should explain further please let me know!

Thanks in advance!

 

 

I am currently using Microsoft 10 Enterprise

1 Reply
best response confirmed by keerath (New Contributor)
Solution

I got it, at least it works for me.

 

=XLOOKUP(MAXIFS(D:D,C:C,K12,A:A,K11),D:D,B:B)

This is it just in case anyone wanted to see it as well