Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Select Multiple Cells Conforming to A Certain Criteria Automatically?
Dear all,
I have a big table containing a lot of data in my worksheet. Within a particular column, I want to select cells whose row numbers form an arithmetic progression with a common difference 8(e.g. G6, G14, G22, ...). At the moment, I can only perform this task by selecting the cells individually while pressing "Ctrl", however, due to the large number of data in the table, this work is very tedious. Does anyone know if there is an automatic way to select these cells? Thank you. Best wishes, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select multiple criteria multiple worksheets | Excel Worksheet Functions | |||
Select by multiple criteria (Excel 2003) | Excel Worksheet Functions | |||
Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |