Rank Data with Errors | Rank Function in Google Sheets | Google Sheets Tips and Tricks

Ranking Data in Google Sheets is a must know. The problem is that you rarely ever work with data sets that don’t have any #Divide/0! Errors (or other errors). This video will teach you how to rank data in an ascending or descending manner - excluding errors from the data set.
If you stick around until the end, I’ll give you a bonus less to rank data sets using the query function.
Join me on Social Media
· Facebook: / 344454936502236
#Googlesheets #Rankformula #Tutorial #TipsandTricks

[@keabogada]

Continue making these awesome educational videos.

[@musicescape2003]

Amazing video. Continue to make these awesome videos.

[@RicardoRLira]

Thank you very much!

[@TimeMeddler]

Great video. I learned about the Query function, which I had not used before and I can now see that it is a very powerful function indeed. Thank you. 👍

[@whyworksmarternotharder]

Great to hear!

[@meltunsi]

How to create 3 months rank for accuracy? Or create a ranking containing several metrics?

[@tiger1x]

But what if I want to rank only specific workers and not all of them? In Excel you can select specific cells and separate them with ; but imported into google sheets it causes an error. How can I solve that problem?
How to make this work in Google Sheets: =RANK(D2,(D2;D4;D5;D7),1) for example?

[@jonathanbartolomin4160]

Amazing video, what if I have multiple employees with the same accuracy. Any idea how you would rank them?

[@whyworksmarternotharder]

Usually I have a different metric that would act as a tie breaker.

[@brightgrantson7]

Use =Rank.Eq(value,locked range,order)

[@kristellekaygloria5728]

Is there a sample video for this? Thanks.

[@sokratakis1995]

make an video for inventory management with google forms. Maybe QR codes too

[@whyworksmarternotharder]

Good ideas!

[@EduardoBicelisGarcia]

Great videos. the first music break sound level excelent! thank you.

[@debrandhub5395]

make a video on educational budget

[@sadashivb5100]

Pls make video on import XML formula..

[@whyworksmarternotharder]

Good idea

[@Chanderv31]

7:00

[@sseonful]

own a laundromat and wanted to know if I can make something to add customers name address and phone number that I can print out for my driver so they can have something like a ticket instead of writing down the info all the time on paper for them

[@whyworksmarternotharder]

Sounds like a video idea

[@GreenTacos]

I kept getting errors but I followed every tutorial there is

[@BBzaimon]

How to get name of rank holder. For example, Wing had best accuracy so when I rank him 1, in next column I want to have name of the rank holders. How to do that?

[@whyworksmarternotharder]

Use a vlookup formula! Sorry for the delay in response! I have a vlookup video
Though

[@Icemeh]

I get "Error RANK has no valid input data" I have exactly the same column with percentage but then for activity. 2 years later maybe google did something in the meantime.

[@gomathyalageswara3781]

HOW TO SORT/RANK SAME GRADE BUT IN SEQUENCE RATHER THEN 123345

[@whyworksmarternotharder]

Not sure I understand the question