filter ?

G

Guest

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?
 
M

Max

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
 

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

Filter - not = 3
Less than, Greater Than, equal to conditional formatting 4
Excel Average dates help 0
Filtering Using Values In A Specific Cell 3
Counting Ages 2
how to count#cells w/= value in other column and not count blank c 4
IF Multiple Conditions 2
Time Value Between Two Times 8

Top