SOLVED

New Contributor

# Tracker Ranking Trouble

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!

I am currently using Microsoft 10 Enterprise

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