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. 👍
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?
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.
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
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?
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. 👍
Great to hear!
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?
Continue making these awesome educational videos.
Amazing video. Continue to make these awesome videos.
Thank you very much!
How to create 3 months rank for accuracy? Or create a ranking containing several metrics?
Pls make video on import XML formula..
Good idea
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.
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
Sounds like a video idea
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?
Use a vlookup formula! Sorry for the delay in response! I have a vlookup video
Though
Amazing video, what if I have multiple employees with the same accuracy. Any idea how you would rank them?
Usually I have a different metric that would act as a tie breaker.
Use =Rank.Eq(value,locked range,order)
Is there a sample video for this? Thanks.
Great videos. the first music break sound level excelent! thank you.
make an video for inventory management with google forms. Maybe QR codes too
Good ideas!
HOW TO SORT/RANK SAME GRADE BUT IN SEQUENCE RATHER THEN 123345
Not sure I understand the question
make a video on educational budget
7:00
I kept getting errors but I followed every tutorial there is