criteria for filtering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

what do you mean? provide an example........
-----Original Message-----
I'm trying to filter only the numbers out of a column
Click to expand...
that contains either numbers or texts. Can someone help
me?
 
You can choose from one of four answers in the column, or else you can type a number in the column. I've already separated them to make a report for each selection except for the numbers.
 
try the function IsNumeric()
-----Original Message-----
You can choose from one of four answers in the column, or
Click to expand...
else you can type a number in the column. I've already
separated them to make a report for each selection except
for the numbers.
 
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

VBA: How can I use a string variable as autofilter criteria? 4
Excel Filter Listview userform VBA 0
Filter a formula 1
query display all records if no criteria entered 3
Multiple criteria in a query 3
Filter subform from combo unbound text box 3
Access Dcount (multiple criteria) 3
filter query 1

Back
Top