Have you tried using the AutoFilter?

Select your row, then from the Data Menu, select Filter, then AutoFilter.

You should now see an arrow in the header row of your column. If you don't
have a header row, then you should add one to use this method. Click this
and you'll see several options for sorting/filtering your data.

HTH,
Elkar


"johnnstacy" wrote:


I have a column within a spreadsheet that has sets of numbers in it. The
numbers are random. For example: 129 245 789 345. What I want to do is
filter these rows and pull out the rows that have just the number 245
in it or bring them to the top or seperate them in some way. Can
someone offer help? Thanks.


--
johnnstacy
------------------------------------------------------------------------
johnnstacy's Profile: http://www.excelforum.com/member.php...o&userid=27302
View this thread: http://www.excelforum.com/showthread...hreadid=541672