Unique Rank in Excel - Combining Rank and CountIF

Thanks Paula, awesome trick.

Thank You Paula !!

nice solution, you need this if you want to sort this list with formulas.
If you have enough collums I would suggest: F2 = B2 + ROW()/10000 and then copy down. Now all the original values are different.

Thanks Paula!

Hi Paula - Is there any way we can rank the values as 1,1,2,3,4,5,6,7 instead of 1,1,3,4,5,6,7,8?

Thank you. it is very helpfull for me. thanks a lot.

any formula to rank text length in excel

mark GPA
850 5.00
870 4.96
840 5.00
866 4.96 How to rank

Hi thanks for the information and the classes

38 to 1
34 to 2
34 to 2
32 to 3
Is there any method to get the ranks as above?
Thank you in advance.

Love u Paula, this what am looking since so far 🙏 BRAVO ✨👏👍🎆

URegarding this video there is a query. I do not want to assign 1 and 2 for same score. I want to keep them on ist position. And next series or rank should show as 2, 3, 4, and so on.... instead of 1,1,3...........I want to show 1, 1, 2 and so on what to do

Thank you so much! So helpful!

What formula should I use to rank students of duplicate scores different on basis of another parameter, which must not be included in score?
For an example, if 2 students got same marks in exam the one with higher attendance will rank higher than the other.

Hi Paula, this is most amazing trick with COUNT-IF. I loved the use of COUNT-IF; where every time the the formula is copied, the range becomes cumulative from the first cell value to the current cell value. Not often such trick is used. Thanks for this wonderful video :)

Very useful!

Thank you for your video, how can Excel produce serial numbers by ranking from small to big after filling any numbers!

Hi Paula! Thank you so much!
I am looking now for a way to make this work on only visible rows.
Do you have any video tutorial about that?

Excellent and more useful Thanks Paula

Paula, many thanks. Clear and easy to follow.

Nice

Thank u so much

Gr8 N tks
it's really help me.

Good.

I'm breaking my head here, how would rank and then untied multiple ties with another ranking formula

Bloody fantastic, ideal and spoken in a language of understanding from a user perspective

Thank you so much, I've been trying to figure this out on my own since 1997!! Such a good video.

Hi Paula, Thanks a bunch, it was a great help

Awesome thanks you so much 😊

Doesn't work rubbish

how can i calc rank

how can i calc rank

thank you. nice explanation

What if there are more three or ore duplicate ranks?

Thank you for this video! It was extremely helpful

Thank you mmam

Beautiful explanation. Thank you!

You nailed it 👌