I’ve been here for the first time, I’d advised one to unsubscribe from one of my friends, maybe someone can solve the problem.

An example of the task that you need to do in the end https://www.planetaexcel.ru/forum/index.php?PAGE_NAME=read&FID=8&TID=8584 How it should look

When changing in the array data, the rating should be changed and re-sorted in ascending order. It would be nice for each change of this data, but if it is impossible, then at least once a day at night, when an array of litas is moving, from where the data for the rating is taken. Rating necessarily with the tenth decimal point. It is possible without hyper, the main thing is that the names and their rating are next, in one or two cells. I do not know how to do it better unfortunately.

Why it doesn't work without a script and how, in theory, the script should solve the problem https://www.planetaexcel.ru/forum/index.php?PAGE_NAME=read&FID=8&TID=18016

While writing this post (or rather I edited this picchu, another problem arose the data stopped wanting to be sorted :(, this function no longer sorts the data as I asked for it on the first screen, even rewriting from scratch, Nathan remains with its 10.9 rating always in the middle (but should go up to the first place). internal view of the formulas used

Help please make this damn real-time rating. I initially thought that it would be much easier and without resorting to scripts in general. My code experience = 0, because this is my first time in my life. And as I understand, Excel's scripts are not at all like Google's scripts, because I could not do it by analogy: C

Thanks in advance for your reply.

  • I think I saw him somewhere today today - Mikhail Rebrov

0