Selecting rows to display

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
 
J

Jason Morin

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
 
F

Freemini

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
 
Top