PULLING OUT CONSECUTIVE ROWS
The cells in Col A contain either "NBR" or "STATUS" or "ITEM".
For example:
NBR
STATUS
NBR
STATUS
NBR <
STATUS <
ITEM <
NBR <
STATUS <
ITEM <
NBR
STATUS
NBR
STATUS
NBR
STATUS
NBR
STATUS
NBR
STATUS
NBR <
STATUS <
ITEM <
NBR
STATUS
NBR
STATUS
NBR <
STATUS <
ITEM <
How can I pull out only the CONSECUTIVE cells containing
"NBR" and "STATUS" and "ITEM"?
(In my example, I've marked these cells with " < ").
|