How to get table data from every 10th row?

Question

WordPress

Tell me, there is a table, let's say for 100 rows, and I need to take every 10th row
, I tried with the help, =OFFSET(A4;10;0)but it's not quite right.
Maybe there is a correct way to take every 10th row from a table of 100 rows

Answer 1

It can be anything: from schoolchildren's games to indexing by some search engine.
Look at the access log, google ip, maybe you will find out who.
But the problem seems to be not in this.
10,000 requests per minute is not a load.
10,000 requests per day - I don’t know what to compare with ...

Answer 2

10k requests per day is not enough. A more or less significant load could be considered such a number of requests per minute. At a minimum, you need to go through the code with a profiler, look for bottlenecks. If such flurries of requests occur regularly, then you can move to a VPS and set up protection .

Answer 3

As for DDOS, no one personally ddosed you, but for example, they could simply pick up passwords for your engine or its components, they could break ssh, and there can be a million such options. And it was not you who was broken here, but the technology that for some reason was chosen by the person who launched this robot, and you fell under a certain criterion by which he decided that you could be hacked.
For example, on December 31, 2012, 100% of sites on Jumul fell on different servers. Since they were looking for a specific vulnerability, they fell within 3-10 minutes.
In general, the meaning is this, be prepared for the brudforcing of even a 1-page site. although the probability of this is extremely small, but this is the Internet. Personally, no one will break you, but there are more than one who want to run a couple of bots. So from time to time you can also get a visit ;)
Well, if this is a regular shared hosting, then it’s not for you, but for your neighbor :)

Answer 4

Let's say the values ​​of the table are in A1:A100
In column B you put down serial numbers from 1 to 100
In column C you write the formula =ИНДЕКС($A$1:$A$100;B1*10)and stretch it.
ps This is the first thing that came to mind, maybe you can do better.
upd/ The example was sent to the mail.
upd2/ you can do this without an auxiliary column=ИНДЕКС($A$1:$A$100;СТРОКА()*10)