filter ?
 

I am trying to filter a column of little league player's ages. The column
contains ages 6-10. I need to list only the 7+, 8 and 8+ year olds.
I have tried custom filter using equal to/greater than 7 and less than or
equal to 8+ but it is not correct. Any help?

filter ?
 

Some / all the age numbers are probably not real numbers

Try this to clean it up

Select any empty cell*, copy the cell
Then select & right-click on the age col,
choose "Paste Special" Check "Add" OK
*to be safe, clear the cell with the Delete key before you copy it

Then try the custom autofilter again
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"sj" wrote in message
...
I am trying to filter a column of little league player's ages. The column
contains ages 6-10. I need to list only the 7+, 8 and 8+ year olds.
I have tried custom filter using equal to/greater than 7 and less than or
equal to 8+ but it is not correct. Any help?