Displaying or Sorting By Rows that Have a Certain Data Requirement

  • Thread starter Thread starter RalphSE
  • Start date Start date
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

:)
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Mailing address block: sorting 1 row to columns 1
problem with a macro autofilter to delet rows 6
Auto Sort 1 column and select data 4
Visible row index after applying a filter in Excel 1
Sort question 1
Extracting data from Multiple columns to a Single row 1
Conditional formatting (by Formula) - few questions 15

Back
Top