ExcelBanter - way to test line before / after, without !REF if delete?

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

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

- - way to test line before / after, without !REF if delete? (https://www.excelbanter.com/excel-discussion-misc-queries/95681-way-test-line-before-after-without-ref-if-delete.html)

nastech

way to test line before / after, without !REF if delete?

Hi, not sure if trick exists for something like the following.
problem arises when deleting a line before / after... lemme guesse, offset?

=IF(C9="","",OR(C9="v1",AND($C$9="w:",C8<"v1",C10 <"v1")))

nastech

way to test line before / after, without !REF if delete?

Think I found it:

=IF(C9="","",OR(C9="v1",AND($C$9="w:",OFFSET(C9,-1,0)<"v1",OFFSET(C9,1,0)<"v1")))

"nastech" wrote:

Hi, not sure if trick exists for something like the following.
problem arises when deleting a line before / after... lemme guesse, offset?

=IF(C9="","",OR(C9="v1",AND($C$9="w:",C8<"v1",C10 <"v1")))

All times are GMT +1. The time now is 01:02 PM.