You could try puting the same concatentation formula...e.g.

= A2 & A3 & A4

into cells B2, B3 and B4. and for the next record

= A5 & A6 & A7

into cells B5, B6 and B7 etc.

Then if you use auto filters you will get all three lines displayed if
you get a match.

Please see the attached spreadsheet.


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4848 |
+-------------------------------------------------------------------+

--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=545608