Filter 3 rows at a time?

[Valiantlyon]

I have 24 items on a spreadsheet, however, each item is composed of 3 rows of data. Can I set up a filter so that when I select/deselect a value it will show/remove all 3 rows?

[lecxe]

Hi

One option is to use an auxilliary column where you repeat each item 3 times. Then filter by the auxilliary column.

Ex.: If your data is in A2:A25, use in B2:

=INDEX($A$2:$A$24,1+FLOOR(ROWS($A$2:A2)-1,3))

Copy down till B25

Now filter by column B