autofilter by non-integer or decimal criteria

[bran]

I have a range of data consisting of integers and non-integers. The non-integers are all numbers with decimals, like 7.1,15.1,16.999, etc. After I filter all the rows containing decimals, I delete those rows. However, while I can do it manually, I cannot figure out the correct criteria code.

I need to figure out the correct criteria value to filter anything containing a "." or non-integer. Either way should work.

 

[Joe4]

One way is to create a helper column to determine if the number is an integer or not, i.e.
=INT(A2)=A2

Integers will return True, decimals will return False.
Then filter on this column.

 

[bran]

Thanks, that does the job