software

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: www.excelforum.com/member.php...oamp;userid=27302
View this thread: www.excelforum.com/showthread...hreadid=541672Have 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,
Elkarquot;johnnstacyquot; wrote:

gt;
gt; I have a column within a spreadsheet that has sets of numbers in it. The
gt; numbers are random. For example: 129 245 789 345. What I want to do is
gt; filter these rows and pull out the rows that have just the number 245
gt; in it or bring them to the top or seperate them in some way. Can
gt; someone offer help? Thanks.
gt;
gt;
gt; --
gt; johnnstacy
gt; ------------------------------------------------------------------------
gt; johnnstacy's Profile: www.excelforum.com/member.php...oamp;userid=27302
gt; View this thread: www.excelforum.com/showthread...hreadid=541672
gt;
gt;


Want to make sure I was clear. Each cell in that column has a group of
numbers as I described. I am trying to sort the spreadsheet and
identify which cells have a particular number and group them together.
Clear as mud? Sorry. Not great at describing.--
johnnstacy
------------------------------------------------------------------------
johnnstacy's Profile: www.excelforum.com/member.php...oamp;userid=27302
View this thread: www.excelforum.com/showthread...hreadid=541672
I did try autofilter but it did not work as expected. In my case I am
looking for the number 129. Within this column there are some cells
with the same set of 6 numbers for example: 111 113 118 129 134. There
are also some cells that just have the number 129. The autofilter isn't
allowing me to pull all the number with 129. It is sorting them into
groups.--
johnnstacy
------------------------------------------------------------------------
johnnstacy's Profile: www.excelforum.com/member.php...oamp;userid=27302
View this thread: www.excelforum.com/showthread...hreadid=541672
Nevermind. I found the custom button. Sorry. I can be dense.....--
johnnstacy
------------------------------------------------------------------------
johnnstacy's Profile: www.excelforum.com/member.php...oamp;userid=27302
View this thread: www.excelforum.com/showthread...hreadid=541672