ExcelBanter - Can Offset() be used in Excel cell formulas when filtered (visible-only)?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can Offset() be used in Excel cell formulas when filtered (visible-only)? (https://www.excelbanter.com/excel-discussion-misc-queries/195522-can-offset-used-excel-cell-formulas-when-filtered-visible-only.html)

[email protected]

Can Offset() be used in Excel cell formulas when filtered (visible-only)?

2003

Situation: If the value in C5 (the next visible row) equals C1 *-1, and other columnar data in row
1 and row 5 I would like to delete both rows.

For this question, can one refer to the next visible row (after filtering) in a sheet-cell formula?

TIA EagleOne

All times are GMT +1. The time now is 05:26 PM.