filtering numbers

[hemsleysut]

I have a very large list of numbers that I want to filter so that I'm left with whole numbers only and the others that are to various decimal places are filtered out. Thanks in advance.

 

[inarbeth]

Place your list in column C with a header (eg list) in C1 and the first number in C2. In cell A1 type a header, eg Filter. In A2 type =C2=INT(C2).
Select a number in column C and do an Advanced Filter: Data, Filter, Advanced Filter. Make your list range the cells in column C and your criteria $A$1:$A$2.