Displaying or Sorting By Rows that Have a Certain Data Requirement

HI,

I've been playing with the autofilter function with no luck, maybe there is a formula that can help me do this -> I am trying to sort a table (there are about 240 rows and many more columns) such that any row that has a value > .615 in it, anywhere in that row, can be identified, so that I can bring those to the top... again, i tried using the autofilter function but couldnt figure it out, then i thought maybe writing some formula saying "if any of the cells in this row are > .615 then say yes" and i could sort by the yes's....would appreciate some help with this please

Maybe you could use another column with a formula in it:

=COUNTIF(A2:Z2,">"&0.615)>0
(adjust the columns to match and drag down that helper column)

then sort/filter by that column.


RalphSE wrote:
>
> HI,
>
> I've been playing with the autofilter function with no luck, maybe
> there is a formula that can help me do this -> I am trying to sort a
> table (there are about 240 rows and many more columns) such that any
> row that has a value > .615 in it, anywhere in that row, can be
> identified, so that I can bring those to the top... again, i tried
> using the autofilter function but couldnt figure it out, then i thought
> maybe writing some formula saying "if any of the cells in this row are >
> 615 then say yes" and i could sort by the yes's....would appreciate
> some help with this please
>
>
>
> --
> RalphSE
> ------------------------------------------------------------------------
> RalphSE's Profile: http://www.excelforum.com/member.php...o&userid=29931
> View this thread: http://www.excelforum.com/showthread...hreadid=521497

--

Dave Peterson

Perfection!!! Thanks!