Jul 30 2021 12:53 PM - edited Jul 30 2021 12:58 PM
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
Jul 30 2021 06:02 PM
SolutionI 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
Jul 30 2021 06:02 PM
SolutionI 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