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?
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?
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.
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!
Amazing video. Continue to make these awesome videos.
Continue making these awesome educational videos.
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?
How to create 3 months rank for accuracy? Or create a ranking containing several metrics?
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
Thank you very much!
Pls make video on import XML formula..
Good idea
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.
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
make an video for inventory management with google forms. Maybe QR codes too
Good ideas!
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.
make a video on educational budget
HOW TO SORT/RANK SAME GRADE BUT IN SEQUENCE RATHER THEN 123345
Not sure I understand the question
I kept getting errors but I followed every tutorial there is
Great videos. the first music break sound level excelent! thank you.
7:00