Find Top 3 Values in Excel (4 Ways) - Work XL

[@sultanaj7461]

Can't thank you enough for this. Life saver indeed!

[@TheKenhal]

Thanks for the appreciation.

[@zyublack09]

you're a life saver. Thank you

[@TheKenhal]

Thanks for such an appreciation. Glad to help you. 👍

[@akhilkl7115]

Thank you sir. And i have a doubt what if we want 6 to 9 rows and then 11 to 15 rows how to avoid in bw them

[@TheKenhal]

If you can identify the rows properly, then mark common number to these rows and sort.

[@TheKenhal]

Else send example data to [e-mail] with desired result.

[@mohamedmumtaz8134]

Thank you for this lecture, just have one question, if we have two or more equal values how we can solve that ??

[@TheKenhal]

I had that video published, but it was not good quality, so I removed it. Will soon upload that video for your answer.

[@hardikthakkarofficial]

shortcut knowledge of excel is awesome

[@TheKenhal]

Thanks 👍🏻

[@OmkarKulavmode-ow6wo]

I like thanks

[@apurvasingh4905]

Thank you Sir

[@user-ll1ox7xq6x]

Excellent.. well explained

[@TheKenhal]

Thanks. Glad to know that.

[@saleemtirur]

I NEED TO LIST TOP 10 VALUE WHICH REPEATED. eg. LIST OUT TOP TEN TEAM SCORED TOTAL GOAL IN EURO CUP 2021.
PLS HELP TO FIND OUT...

[@TheKenhal]

Hi, welcome. Can you please share just list of fields you would like to have in your report, so I can try to make a similar report and see what you want.? Please send your mail at [e-mail]

[@omnism2760]

which is the key to log or make a $f5

[@TheKenhal]

Hi, the function key to apply dollar sign is F4.

[@anirban20091]

Great help. Thanks.

[@TheKenhal]

Glad you liked it 👍

[@sujulovenl5753]

This helped, I just don't understand how to get the name to display in the top 3 list. I tried using INDEX, but it just gives me an error no matter what I try :(

[@TheKenhal]

Hi, if you want the name for the value, maybe you can look at my reverse VLOOKUP video at this link: th-cam.com/video/u36-KKWLuRg/w-d-xo.html

[@fernando5166]

thanks you

[@TheKenhal]

Thanks

[@ammrfarhan]

What if the value is duplicate? For example, I'm showing the name of the Top 1 value, but since there are duplicate value, it is showing two names instead of 1 name only. Please help me I'm stuck.

[@TheKenhal]

Hi Ammar,
The above video includes i card towards end of the video. This i card takes you to another video which shows Top 3 Unique Values in Excel. Here is the link: th-cam.com/video/oRdd4V-3irc/w-d-xo.html
Hope this helps.

[@ammrfarhan]

@@TheKenhal thank you so much for the feedback

[@santunubiswas3051]

How to find rank region wise?

[@TheKenhal]

Hi, whether Region-wise or Performance-wise, you need numbers for ranking. So keep some performance/achievement numbers associated with the Region. Then use RANK to use smallest to largest (ascending), if you want smallest number in the list of values, as Rank 1. Else use RANK largest to smallest (descending).
RANK(Number, Range of Numbers, Order)

[@halfdeadjoker1953]

thanks

[@TheKenhal]

Thanks.

[@keshavtamang2396]

How to lock a formula

[@TheKenhal]

Hi, formula locking is done using $ sign in range or cells. If you want formula lock meaning protection then that depends upon sheet protection.
Planning a common video to explain these two things together to clear any doubts. Kindly wait for some days.
Thanks.

[@keshavtamang2396]

@@TheKenhal thank you

[@niravsapariya5575]

My comments is why locked data

[@TheKenhal]

When we copy formula, cell addresses should normally be locked. In a new column along the table however, we can avoid locking. But ranges should always be locked while copying. (Apologies for delayed reply).

[@purushothamanreddy]

Hi Sir, Thank u.
I want the same with name and number rather than mentioning top 3

[@TheKenhal]

Hi, thanks.
Function Large can give you top three values. Please look at Reverse VLOOKUP video. The link is given here th-cam.com/video/u36-KKWLuRg/w-d-xo.html
This gives you name and number.