| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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"))) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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"))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't delete a cell without deleting a row | Excel Discussion (Misc queries) | |||
| How to add a vertical line to a Line Chart that aleady has 2 Y axi | Charts and Charting in Excel | |||
| Change line in Chart | Charts and Charting in Excel | |||
| Line delete automaticaly | Excel Discussion (Misc queries) | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Linear Mode
