Ignoring blank cells when sorting numbers

  • Resolved jmoorfoot

    (@jmoorfoot)


    5 years, 9 months ago

    Hi,

    First I would like to say well done on such a great plugin.

    I am currently using the plugins to display a rankings speadsheet on a website. At the moment when you sort by an individual’s rankings it shows players with blank cells at the top. e.g

    Blank
    Blank
    1
    2
    3

    Is there a way to have it so the sort functionality ignore blank cells so they display at the end e.g.

    1
    2
    3
    Blank
    Blank

    If possible I would also like them to display at the end if sorting descending e.g.

    3
    2
    1
    Blank
    Blank

    Thanks in advance

    Jon

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Meitar

    (@meitar)

    ˉ\_(ツ)_/ˉ Reverse the current sort order?

    Thread Starter jmoorfoot

    (@jmoorfoot)

    Hi, I am not sure that I made my query clear as it is not that I want to be able to display them in descending in ascending order. I want it so the sort functionality ignores blank cells and always has them at the end of the list after any actual values regardless of whether it is sorted in ascending or descending order.

    Ascending Currently displays – it reads blank cells as the lowest value and so when sorted ascending it places blank cells above any cells with values in (as shown below).

    Blank
    Blank
    1
    2
    3

    I would like ascending to display:

    1
    2
    3
    Blank
    Blank

    I would still like blank cells to display at the end if it is in descending order as well e.g.

    3
    2
    1
    Blank
    Blank

    I mention this as one potential fix I saw suggested giving the blank values a really high number but then that would result in the blank cells showing at the top when sorting in descending order which I would also want to avoid.

    Plugin Author Meitar

    (@meitar)

    Define your own sort order, then.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Ignoring blank cells when sorting numbers’ is closed to new replies.