Displaying or Sorting By Rows that Have a Certain Data Requirement

R

RalphSE

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

:)
 
D

Dave Peterson

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.
 
Top