Forum Discussion
selecting every 46th row in excel then copy/ paste into new page
Hi, I have approx. 160,000 rows of data Ideally I want to choose every 46th row; and then use them as my sample. OR How can I choose 3466 random rows from an excel document of 160,000 and put in ...
you can use
=chooserows(A1:Z160000, sequence(int(160000/46),,46,46))
for random
=chooserows(A1:Z160000, randarray(3466,,1,160000,TRUE))
