[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

Filter a column for any occurrence of a digit

Hello, I would like to filter a column I'm excel.  The criteria would be any digit.  How can I do this?  

Thank you
0
pdvsa
Asked:
pdvsa
  • 2
1 Solution
 
Glenn RayExcel VBA DeveloperCommented:
I don't know any filter/wildcard method that will filter on cells that contain whole numbers (0 - 9).  But you can do this with a helper column that will identify if the original cell contains any digits.

If your original data is in column A, add this array formula (using [Ctrl]+[Shift]+[Enter]) in an adjacent column and then copy it down as far as needed:
=OR(ISNUMBER(VALUE(MID($A2,ROW($A$1:$A$100),1))))

You'll see TRUE or FALSE values:  TRUE means there is at least one digit in the original cell.

Regards,
-Glenn
0
 
pdvsaAuthor Commented:
perfect!  thank you very much.
0
 
Glenn RayExcel VBA DeveloperCommented:
You're welcome.  I'm going to hang onto this formula; it might prove useful in data checks.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now