View Single Post
  #3   Report Post  
Tom Peacock
 
Posts: n/a
Default

Assuming your numbers start in cell A1. Put this formula =A1=TRUNC(A1,0)
into cell B2 and copy it all the way down. Integers in column A will have
TRUE in column B those cells with decimals will have FALSE nest to them.
Sort both columns by column B. Integers and non-integers are now grouped,
delete all the rows that have FALSE in column B.

Tom