Thanks!

Can do one for start time and end time for task . when the start bottom is pressed it’s deactivated and the end bottom is active to click when task is complete. It will also capture their email and name and task and at the calculate how long it took to complete the task

First thank you for your all videos my bottom is not work is there alternative solution for my issue

Will it work in Google sheet too ?

can you tell which function to use for relative numbering in google sheets. for example- I have ranks of 400 cities from which I selected 45 cities with population more than million, but their rank is as per the 400 ranking list: a=2, b=65, c=289, d=17, ...) But now I want to rank them in ascending order with ranks between 1-45. Please help

@ExcelGoogleSheets

Жыл бұрын

SORTN or QUERY

These web scripts are quite low I would say.

Why are office scripts so much slower then VBA? If you create similar code for VBA its gonna execute this entry without any delay when you press that button. Office script are only acceptable if you execute them directly...This is so simple code but still so slow.

@jstephen

28 күн бұрын

Office Scripts are not stored in the document so when you go to run them they have to be pulled from the cloud location they are stored then once they get loaded they can run. If you run one and then run it again you will notice the second run is much faster, unfortunately if you run a different one then go back to it again has to be loaded. Yes this is quite painful, and MS should do something about this.