Filtering Worksheets by the numbers after a decimal place?

D

David

Carl,

One way:
Insert a new column next to your 'numbers' column.
If your numbers are in range A2 downwards, in the new
column, in row 2 ,type the following formula:
=IF(INT(A2)=A2,"Whole Number","Decimals")
Then filter on the new column
Cordially,
David
 

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

Mail Merge - displaying a conditional number of decimals 5
Displaying Returns from another worksheet that change? 3
Counting multiple occcurrences between date range 3
Finding the proper style field and the numbered paragraph value within the style 0
Addition errors with Decimal Places 6
matching 1 to 1 and 1 with variations... 3
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Problem entering numbers 3

Top