+ Reply to Thread
Results 1 to 5 of 5

Sorting lists of numbers in pairs and in ascending order

  1. #1
    Registered User
    Join Date
    11-02-2020
    Location
    Aberdeen
    MS-Off Ver
    10
    Posts
    11

    Sorting lists of numbers in pairs and in ascending order

    Dear members,
    There's these list of numbers I have attached. You will notice that there are duplicate numbers which are representing time (in minutes). Here comes my questions:
    1. What formula or function or code can I use to remove all the duplicates in "Time" column and populate the "Time after removing the duplicates" column with unique Time values.
    2. I will like to populate the "Difference in time" column with the ascending change in time. For example for this data we will have start and end time as follows: 0 to 1. 1 to 30, 30 to 60, 60 to 120, 120 to 179, and 179 to 180. So the Difference in time for 0 to 1 = 1, 1 to 30 = 29, 30 to 60 =30, etc.
    Attached Files Attached Files
    Last edited by Lekan17; 11-03-2020 at 10:21 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Sorting lists of numbers in pairs and in ascending order

    Where did the 1 come from? I do not see it. Please attach your sheet, not a picture of it (after checking the missing 1). See yellow banner at top of page.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    11-02-2020
    Location
    Aberdeen
    MS-Off Ver
    10
    Posts
    11

    Re: Sorting lists of numbers in pairs and in ascending order

    Dear Glenn,
    I have updated the attached file as appropriate. Thanks

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Sorting lists of numbers in pairs and in ascending order

    F11:
    =iferror(aggregate(15,6,$e$11:$e$24/(countif(f$10:f10,$e$11:$e$24)=0),1),"")

    g11:
    =if(f11="","",iferror(f11-f10,0))
    Attached Files Attached Files

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Sorting lists of numbers in pairs and in ascending order

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

+ 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. sorting ascending and descending order
    By beepetark in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-30-2019, 01:10 PM
  2. [SOLVED] Sorting Columns in Ascending Order
    By COLIN_303 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2013, 07:51 AM
  3. sorting numbers into ascending order
    By stevy123 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-03-2012, 08:00 AM
  4. x axis ascending order without sorting
    By vbidiot in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-30-2008, 09:31 AM
  5. Sorting Data in ascending order
    By sharon2006 in forum Excel General
    Replies: 1
    Last Post: 03-13-2006, 09:10 PM
  6. Sorting Numbers in Ascending or Descending Order
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-28-2005, 11:25 AM
  7. sorting number in ascending order
    By Janice Lee via OfficeKB.com in forum Excel General
    Replies: 2
    Last Post: 04-08-2005, 06:06 PM

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