OFFSET is great for selecting any new location from the current cell. But if that new location happens to be hidden, OFFSET doesn't care.
How can I select a certain range away from the current cell, counting *visible* cells only?
|
OFFSET is great for selecting any new location from the current cell. But if that new location happens to be hidden, OFFSET doesn't care.
How can I select a certain range away from the current cell, counting *visible* cells only?
| All times are GMT -7. The time now is 02:06 PM. |