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 ...
=FILTER(A1:F160000,MOD(ROW(A1:F160000),46)=0)
If you have access to the FILTER function you can use this formula.
In legacy Excel e.g. Excel 2013 you can use Advanced Filter or Power Query.