Filtering data
 

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?

Filtering data
 

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

On Mar 2, 11:20 pm, S. Kissing
wrote:
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?

Filtering data
 

Hi

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

DataFilterAutofilter and filter for TRUE on the new column

--
Regards

Roger Govier


"S. Kissing" wrote in message
...
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?

Filtering data
 

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


"S. Kissing" wrote:

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?