Results 1 to 5 of 5

Thread: Data sorting

  1. #1
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007

    Post Data sorting



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    How to sorting data through formula.

    pl find attached "Example.xlsx"
    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    Use this array formula

    =INDEX($D$4:$D$15,SMALL(IF($C$4:$C$15=$G$5,ROW($D$4:$D$15)),ROW(A1))-ROW($D$3))

  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Bob Sir,
    I put the above formula in my excel file. it is not working. can u please provide the excel file "Example.xlsx" using the above array formula.

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,820
    Articles
    0
    Excel Version
    O365
    Did you arry-enter it (Ctrl-Shift-Enter)?

  5. #5
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    yes, i have entered ctrl-shift-Enter.

Posting Permissions

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