Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need a filter which will show all rows n and n+1, if and only if, in row n,
A=1 and B=1, and in row n+1, A=0, B=2 and C=4; or, in row n, A=0, B=1 and C=4, and in row n+1, A=1 and B=2. In other words, whether or not a row is to be displayed depends not only on what is in the row but also on what is in the preceding row or the following row. Can you tell me how to do this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
a special filter? | Excel Discussion (Misc queries) | |||
Copy & paste special under a filter | Excel Discussion (Misc queries) | |||
Web query and special characters | Excel Programming | |||
filter with special forrmating | Excel Programming | |||
Web query and special characters | Excel Programming |