Forum Discussion

nir_g's avatar
nir_g
Copper Contributor
Apr 20, 2020

Creating a smaller array from a large one

Hi, this question might have a simple answer, I hope it does. Perhaps you can help? I have a pretty large data array (say 10,000 rows and 80 columns) and would like to create a smaller array from it ...
BI & Data Analysis
excel
office 365
DhaniCole's avatar
DhaniCole
Brass Contributor
Apr 20, 2020

nir_g 

You could add a column with the formula =IF(MOD(ROW()-1,10)=0,"Yes",""), then filter down to the "Yes" and you have your smaller dataset.

  • nir_g's avatar
    nir_g
    Copper Contributor
    Apr 21, 2020

    DhaniCole 

    Thank you, nice and simple 🙂

Resources