View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GARY GARY is offline
external usenet poster
 
Posts: 117
Default 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 " < ").