+ Reply to Thread
Results 1 to 3 of 3

Sorting numerical data including negative figures

  1. #1
    Registered User
    Join Date
    09-29-2020
    Location
    Suffolk, England
    MS-Off Ver
    2016
    Posts
    1

    Sorting numerical data including negative figures

    Hi all - total newbie here so you will have to use laymen's terms for me!

    I have a spreadsheet that shows employees working times (in HH:MM), breaks, allocated work times and percentages of the difference between time worked and time due. I am trying to sort the data by department - easy done. I'm then trying to sort by variance which is a formulated column of =AN3-AM3 and the cells are formatted as custom hh:mm. Some of these cells show a negative figure and I need to sort it by lowest to highest. Keeps throwing up errors and won't let me do it OR it does it but not in order. Just chucks them anywhere.
    I hope I've explained it well enough, please let me know if you need any more info.
    Thank You

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Sorting numerical data including negative figures

    Hi

    Maybe you need to use a helper column.

    If your variance is in A1 and is -12 then =ABS(A1) will return 12
    If your variance is in A2 and is 12 then =ABS(A2) will also return 12

    So sorting by column be will return a list of variance in numerical order.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    04-26-2020
    Location
    Massachusetts
    MS-Off Ver
    Office 365
    Posts
    93

    Re: Sorting numerical data including negative figures

    If mehmetcik solved your problem there is no need, but otherwise Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you
    have removed any private information, remember this is a public forum and so available to anyone.
    We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 01-24-2020, 10:22 AM
  2. Numerical sorting a group of data?
    By Fessy82 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-01-2015, 03:54 PM
  3. automatic sorting names based on numerical data
    By Littlesimon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2015, 11:46 PM
  4. [SOLVED] Sorting numerical data in a pivot table
    By katieshields in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-25-2013, 04:20 AM
  5. Sorting Numerical data..
    By Hodged in forum Excel General
    Replies: 4
    Last Post: 11-06-2006, 06:18 AM
  6. Replies: 3
    Last Post: 01-17-2006, 10:10 AM
  7. Having trouble sorting numerical data from SQL analysis cube
    By Andy S. in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-17-2006, 10:10 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1