Results 1 to 2 of 2

Thread: Filter where not whole number

Threaded View

  1. #1

    Question Filter where not whole number

    Is there a way that I can split my data where it is not a whole number?

    I'm currently getting creative, but would like to know if there is an easier way.

    Currently I am using ceiling to get the highest integer, then dividing that back by the original value and splitting where the result is > 1.

    Example
    11.46
    12.0
    12.06
    12.08
    12.39
    13.0
    14.0

    Output 1
    12.0
    13.0
    14.0

    Output 2
    11.46
    12.06
    12.08
    12.39

    Thanks,
    J
    Last edited by jchartrand; 07-10-2018 at 07:52 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •