Results 1 to 2 of 2

Thread: Sort Data In Excel Using Formula

  1. #1
    Member Rajan_Verma's Avatar
    Join Date
    Sep 2011
    Posts
    81
    Rep Power
    13

    Lightbulb Sort Data In Excel Using Formula

    Rajan Verma has posted the following on 06-28-2014 02:31 PM:

    Excel provides SMALL and LARGE formula to get sorted numeric values , but sometime we need our string/text data to be sorted by formula only. Though, there is an inbuilt sorting feature available in excel, but here I am going to demonstrate a formula. So, Lets say you have your data list in Range “A1:A10″, […]

    Sort data by excel formula

  2. #2
    Junior Member
    Join Date
    Feb 2014
    Posts
    1
    Rep Power
    0
    Good one.

    Also try this one that I got from Bob Umlas:

    Code:
    =INDEX(mylist,MATCH(SMALL(COUNTIF(mylist,"<="&mylist),ROWS($1:1)),COUNTIF(mylist,"<="&mylist),0))
    It must also be committed with Control+Shift+Enter and dragged down.

    Hope this helps.
    Last edited by FlameRetired; 07-08-2014 at 10:05 AM.

Similar Threads

  1. Replies: 5
    Last Post: 01-08-2014, 04:54 PM
  2. Sort Data Using Formula To Find Top X
    By mahmoud-lee in forum Excel Help
    Replies: 12
    Last Post: 06-02-2013, 10:13 PM
  3. Sort data sheet by right_click of mouse
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 3
    Last Post: 12-08-2012, 07:34 PM
  4. Excel Macro to Sort Data if a value changes in defined range
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 09-05-2012, 10:31 AM
  5. Sort Data When a Header Is Clicked
    By Rasm in forum Excel Help
    Replies: 9
    Last Post: 08-01-2012, 06:46 AM

Posting Permissions

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