创建仅包含整数的列表 [英] Creating a List of only Whole Numbers

问题描述

我正在尝试从另一个列表中创建一个仅包含整数的列表.假设我的范围列表是:

I am trying to create a list of only whole numbers from another list. Suppose my range list is:

我希望结果显示为:

我希望该解决方案仅适用于 excel 2019.任何帮助将不胜感激，谢谢.

I want the solution to work in excel 2019 only. Any help would be appreciated, thank you.

推荐答案

如果你有 Office 365 你可以使用 =FILTER(A1:A6,INT(A1:A6)=A1:A6)对于旧版本: =IFERROR(INDEX($A$1:$A$6,SMALL(IF(INT($A$1:$A$6)=$A$1:$A$6,ROW($A$1:$A$6)),ROWS($1:1))),"") 这个应该用ctrl+shift+enter

If you have office 365 you could use =FILTER(A1:A6,INT(A1:A6)=A1:A6) For older versions: =IFERROR(INDEX($A$1:$A$6,SMALL(IF(INT($A$1:$A$6)=$A$1:$A$6,ROW($A$1:$A$6)),ROWS($1:1))),"") this should be entered withctrl+shift+enter

这篇关于创建仅包含整数的列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！