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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")))
 
Think I found it:

=IF(C9="","",OR(C9="v1",AND($C$9="w:",OFFSET(C9,-1,0)<>"v1",OFFSET(C9,1,0)<>"v1")))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#Ref! after row deletion 3
Code to Implement Required Cells Not Working 3
margin calc 2
Deleting rows in a range using Autofilter 3
faster macro 6
If named sheet exists then delete it 9
Copying Charts - Memory Leak - Excel 2003 2
Testing if data already imported 3

Back
Top