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,
|