Filtering data

[Guest]

I have a large spreadsheet and I want to filter by chosing every 9 rows,
i.e., row 1, 9, 18, etc....Help, is this possible?

 

[Pete_UK]

In a helper column you could enter a formula like:

=MOD(ROW(),9)

and copy this down. This will give you repeating patterns of 1 to 8
then 0 to 8, so to select the 9th, 18th, 27th row etc you would select
0 from the filter drop-down.

Hope this helps.

Pete

 

[Roger Govier]

Hi

Use a spar column as a helper column. Enter the formula
=MOD(ROW(),9)=0
and copy down

Data>Filter>Autofilter and filter for TRUE on the new column

 

[Guest]

Every 9 rows is not 1, 9, 18

It is 1, 10, 19, ...


You can use this macro to hide rows

Sub HideRows()
'
' Macro1 Macro
' Macro recorded 3/2/2007
'

'
For i = 0 To 1000 Step 10

Rows("2:10").Offset(rowoffset:=i, columnoffset:=0).Select
Selection.EntireRow.Hidden = True
Next i
End Sub