Forum Discussion
Hiding rows in an excel
I am looking for any suggestion on a quick way to hide multiple rows in and excel spread sheet. I have logged approximately 16000 lines of data and I need to hide 9 rows, keep the 10th row visible, ...
David70 As a variant, I attach a solution with the FILTER function that does not require a helper column. Furthermore, it automatically detects the used range in the numbers column (A in the attached example). One single formula in F1 returns a dynamic table of all 10th rows from the original data.
Depending on your Excel version, though, FILTER might not (yet) be supported.
=FILTER($A$1:INDEX($D:$D,MATCH(99^99,$A:$A)),MOD(ROW($A$1:INDEX($A:$A,MATCH(99^99,$A:$A))),10)=0)