Sort Column with Negative Currency

Viewing 1 replies (of 1 total)
  • Thread Starter tylerforret

    (@tylerforret)

    Additionally, I seem to have a problem if some cells in the table are blank. e.g.

    HEADER
    -120

    +200
    +400

    It seems to sort this as if it were a “0” instead of no data. Is there any way to have these show at the end of the table when a column is sorted (both ways since it is an irrelevant cell”).

    e.g.

    HEADER (Asc)
    -120
    +200
    +400
    BLANK CELL

    HEADER (Desc)
    +400
    +200
    -120
    BLANK CELL

    Thanks!

Viewing 1 replies (of 1 total)
  • The topic ‘Sort Column with Negative Currency’ is closed to new replies.