I often work with spreadsheets that have what I call records, or data
that is logically associated in groups of three rows. What I want to
do is to strip out any records (three rows) that don't meet a certain
criteria, like say "2nd row does not contain xxxxx", i.e things that I
can do row at a time in a filtered list. If I could just somehow tell
the filter command to include the row above and the row below the
match, that would be great.

I tried a formula, but as far as I know they can't do "does not
contain", and I can't use < because I am matching a piece of text
within a string.

Would a "3 X something" array somehow work? I've never used arrays
before but that sounds promising to me.

Thanks!


--
Spalding
------------------------------------------------------------------------
Spalding's Profile: http://www.excelforum.com/member.php...fo&userid=8634
View this thread: http://www.excelforum.com/showthread...hreadid=545608