Another cool tip - sampling every n row:
use this formula:
=index($A$2:$A$130764,ROWS(K$2:K2)*125)
adapt the red sections to the range you need and the specific n rows number you need.
Another cool tip - sampling every n row:
use this formula:
=index($A$2:$A$130764,ROWS(K$2:K2)*125)
adapt the red sections to the range you need and the specific n rows number you need.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks