Title: Order numbers only
Last modified: August 25, 2021

---

# Order numbers only

 *  Resolved [profodes](https://wordpress.org/support/users/profodes/)
 * (@profodes)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/order-numbers-only/)
 * Hello Tobias,
 * Hope you’re doing well.
    I have a question regarding the order option… I’m running
   a F1 league and for the standings I use table press. Results are like 25,18,15,12,10,8,6,4,2,1
   DNF, DNR.
 * Now when I try to order it… for some reason it doesn’t order from “high to low”
   in the columns for the race results… but it does for overal points… Reason I 
   think is because in the overall points it doesn’t show DNF/DNR. In the race results
   it does.
    The results are ordered like this: 10,15,18,2,20,25,3,4,6,8,DNF,DNF,
   DNF,DNF,DNR,DNR,DNR.
 * Any idea how this can be like 25,18,15,12,10,8,6,4,2,1 DNF, DNR.?
 * Kind regards,
    Roland
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Forder-numbers-only%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/order-numbers-only/#post-14806575)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * Indeed, this is caused by the “DNF”/”DNR” entries. These cause the sorting algorithm
   to switch from number sorting to text sorting.
    One solution for this would be
   to add a duplicate of this column, where you use numbers (maybe 0 or some where
   high number like 1000) instead of “DNF”/”DNR”. Then, you can use the approach
   from [https://wordpress.org/support/topic/date-order-6/](https://wordpress.org/support/topic/date-order-6/)
   to use this new column for the sorting (but hide it from the site visitor).
 * Regards,
    Tobias
 *  Thread Starter [profodes](https://wordpress.org/support/users/profodes/)
 * (@profodes)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/order-numbers-only/#post-14815143)
 * Thank you very much Tobias.
 * I have another question:
    Is it possible to have a table which takes information
   out of a specific cell from another table made in TablePress?
 * Kind regards,
    Roland
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/order-numbers-only/#post-14817788)
 * Hi Roland,
 * no problem!
 * For your other question: It’s not possible to run SQL like queries for data or
   similar, but to extract single values (for use somewhere on the site, or in another
   table), you could use the TablePress Extension from [https://tablepress.org/extensions/table-cell-shortcode/](https://tablepress.org/extensions/table-cell-shortcode/)
 * Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Order numbers only’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [4 years, 9 months ago](https://wordpress.org/support/topic/order-numbers-only/#post-14817788)
 * Status: resolved