Sorry to bother you, I would like to make an Android data entry app that sends the info to Excel. Do you have video any videos that would help me there? 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
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
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.
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.
Sorry to bother you, I would like to make an Android data entry app that sends the info to Excel.
Do you have video any videos that would help me there?
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
Thanks!
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
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.
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.