Selecting rows to display

  • Thread starter Thread starter JohnEd
  • Start date Start date
J

JohnEd

I have a spreadsheet with approx 200 rows.

One of the columns displays a figure between 25 and 60 on each row.
need to simply view the rows with figures over 50 either by running
report or filtering the numbers. Any ideas
 
Try an AutoFilter (Data > Filter > AutoFilter).
Select "Custom" in the drop down box for that column and
specify greater than 50.

HTH
Jason
Atlanta, GA
 
If you use autofilter on the column with your numbers between 25 an
60.

Then you will be able to filter using the custom option and the "Equa
to or greater than" condition with 50 in the value box.

If you have rows above and/or below the data you should leave these ou
of the filter area.

Hope this helps

Mik
 

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

Numbering Rows in Filtered Data - Excel 2002 3
Inserting rows using a list of numbers 3
Aligning rows. Help... 1
Display columns or rows based on values 1
Need V-Lookup to Return A Row, Not Just Single Value 2
Page break dosen't break 4
Find last entry in a row 8
Sorting in Numerical Order 4

Back
Top