Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to select every third cell in a very long column of data?
Is there a formula or an easy way to select/highlight every third cell in a
very long column of data? -- Thanks, Jamie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to select every third cell in a very long column of data?
hi,
formulas return values from other cells but they cannot perform actions like select another cell. Multiple selects are possible but you can run into problems depending with what you wish to do. this macro will highlight every third cell edit to fit your data. Sub everythird() Dim r As Range Dim rd As Range Set r = Range("A2") Do While Not IsEmpty(r) Set rd = r.Offset(3, 0) r.Interior.ColorIndex = 40 Set r = rd Loop End Sub regards FSt1 "jme951" wrote: Is there a formula or an easy way to select/highlight every third cell in a very long column of data? -- Thanks, Jamie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to select every third cell in a very long column of data?
In a helper column adjacent to your set of data, you can enter a
formula like: =MOD(ROW(),3) and copy this down. This will return values of 0, 1, and 2 down the column. If you apply an autofilter to this column you can select which of these values you want to display - suppose you choose 0. Then you can click on the first visible cell, hold down <SHIFT, press <End once followed by <down, and then release <SHIFT. Without clicking on another cell, use the pull-down on the filter to select All, and then you will have every third cell highlighted. Hope this helps. Pete On Nov 21, 6:51 pm, jme951 wrote: Is there a formula or an easy way to select/highlight every third cell in a very long column of data? -- Thanks, Jamie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut to select column with data in previous column | Excel Discussion (Misc queries) | |||
Multiple columns of data into one long column | Excel Discussion (Misc queries) | |||
In Excel: select the last 20 rows of data in a column | Excel Worksheet Functions | |||
long formula obscures cell view | Excel Discussion (Misc queries) | |||
I want to select the first blank cell in column A | Excel Worksheet Functions |