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!
Try this array formula
Please Login or Register to view this content.
❖ Please mark your thread is SOLVED if there has been offered a solution that works fine for you.
❖ If you like solutions provided by anyone, feel free to add reputation by clicking on ✶ Add Reputation bottom left of their posts.
Thanks alot! works well!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks