Hi Guys,
Can you help me determine on how to use the rank formula in excel.
I tried using =RANK($D2,$D$2:$D$9) but it doesnt give me my desired return. Its skipping the 2nd place.
It is possible that there will be a tie so i want to show that both are in the 1st place, 2nd place or 3rd.
I have attached the excel with my current formula vs what im getting.
Thank you!
Bookmarks