+ Reply to Thread
Results 1 to 4 of 4

Sorting data numerically that contains both numbers and text

  1. #1
    Registered User
    Join Date
    11-25-2014
    Location
    CA
    MS-Off Ver
    2010
    Posts
    2

    Sorting data numerically that contains both numbers and text

    Hello there. I am using a quiz program along with an ILMS and the ILMS is not transferring over data correctly such as the question text and the ILMS is reordering the questions so they do not appear in order as shown in the original quiz file. This affects the look of the quiz results when exported from the ILMS into an Excel file.

    The quickest way for me to use this data (quiz results) which is exported from the ILMS into Excel is to see if I can sort the 'Question' field by the 'Slide#' i.e. Slide 3, Slide 4, etc. This is not working. Can someone help me set the parameters or let me know how I can sort so the questions and answers are in order for reporting purposes?

    The Slide number tells me the question order as it appears in the original quiz file.

    Link to image: http://i62.tinypic.com/mtsbvo.jpg
    Link to Excel doc: http://www.docdroid.net/lvc8/question-excel.xlsx.html
    Attached Images Attached Images
    Last edited by mkdockery; 11-25-2014 at 07:19 PM.

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Sorting data numerically that contains both numbers and text

    If you need the results with formula, pls check this out, I am using Helper Column for avoid complication. And for sort formula I am using array formula, means when ENTERING this formula, you need to confirm press CTRL+SHIFT+ENTER button together, and other formula just regular formula or just hit ENTER.

    Hope this clear
    Azumi
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-25-2014
    Location
    CA
    MS-Off Ver
    2010
    Posts
    2

    Re: Sorting data numerically that contains both numbers and text

    Thank you!!! This is very advanced and works perfectly.

    Have a great holiday!!!! =D

    Best,

    Myah

  4. #4
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Sorting data numerically that contains both numbers and text

    Thanks for providing feedback too

    cheers

+ 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: 7
    Last Post: 07-02-2012, 07:23 PM
  2. Extracting Numbers From Text Range And Sorting Numerically
    By jon87 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-29-2012, 10:15 AM
  3. Text and numbers that I want sorted numerically
    By AG65 in forum Excel General
    Replies: 12
    Last Post: 03-15-2012, 08:45 AM
  4. Sorting numerically
    By jmflu in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-16-2011, 01:27 AM
  5. [SOLVED] Sorting numerically
    By Daniel in forum Excel General
    Replies: 2
    Last Post: 01-18-2005, 10:06 PM

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