How to filter only integer numbers (whole numbers) or decimal numbers in Excel

preview_player
Показать описание
If there is a list of numbers in your worksheet which contain whole numbers (integers) and decimal numbers, now you want to filter only the integers or non-integers from the list data as following screenshots shown, how could you solve it in Excel?

More details:
Рекомендации по теме
welcome to shbcf.ru