How do I filter a cell to look for anything w/ text vs numbers?

  • Thread starter Thread starter Filtering out numbers vs text
  • Start date Start date
F

Filtering out numbers vs text

I have a spreadsheet with data that has numbers and/or text. How do I filter
out the data with only numbers?
 
In a helper column you can introduce a formula like:

=ISNUMBER(A2)

assuming your values are in column A. Copy this down and it will give
TRUE or FALSE, and you can filter on this.

Hope this helps.

Pete
 
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

How to use the value in a cell to run a query 1
Subtotal function for text 3
My filter does not pick up all text 5
problem with fractions to decimal 1
Subtotal data excluding negitive numbers. 3
filter on currency number format 3
pasting with filter results into sequentual cells not same row? 1
Count function in Auto-Filtered data 1

Back
Top