Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to select every 10th line of data in an excel spreadsheet?
Is this possible?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to select every 10th line of data in an excel spreadsheet?
Yes.
=MOD(ROW(),10) and Autofilter. -- David Biddulph "Matloter" wrote in message ... Is this possible? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to select every 10th line of data in an excel spreadsheet?
One way... This starts at row 2 and selects every 10th populated row after
that... Sub Select10Th() Dim rng As Range Dim rngAll As Range Set rng = Rows(2) Set rngAll = rng Do While Application.WorksheetFunction.CountA(rng) 0 Set rngAll = Union(rng, rngAll) Set rng = rng.Offset(10, 0) Loop rngAll.Select End Sub -- HTH... Jim Thomlinson "Matloter" wrote: Is this possible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to select every 10th line of data in an excel spreadsheet?
Here's one way
If A10:A200 contains your data, with A10 the column heading (eg....MyData) Try this: A1: Crit A2: =MOD(ROW(A11),10)=0 Note: That formula refers to the FIRST DATA cell, NOT the heading Select A10:A200 From the Excel Main Menu: <data<filter<advanced filter Criteria Range: $A$1:$A$2 Click [OK] Now only these data rows will be displayed: 20, 30, 40, 50, 60, 70, 80, 90, 100, 110, 120, 130, 140, 150, 160, 170, 180, 190, 200 Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Matloter" wrote in message ... Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Draw Line every 10th Row | Excel Worksheet Functions | |||
Showing data as spreadsheet and a line graph. | New Users to Excel | |||
How do I get to the last line of a large spreadsheet to add data | Excel Worksheet Functions | |||
Select every 10th number in a list | Excel Discussion (Misc queries) | |||
can i get excel to choose every 10th entry in a spreadsheet | Excel Worksheet Functions |