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:








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:








 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)

I got it, at least it works for me.



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