+ Reply to Thread
Results 1 to 4 of 4

some questions about sorting with multi conditions

  1. #1
    Registered User
    Join Date
    01-16-2018
    Location
    taiwan
    MS-Off Ver
    2010
    Posts
    19

    some questions about sorting with multi conditions

    Hi,

    I would like to calculate some result by sorting function, what should I use the excel formula?

    1. in (I2), make a result of how many days between "tom" last winning(rank 1) date till the date I fill in (F2).

    2. in (J2), by filling track(H2)-(please note that I want to group the track i.e A2=A & A2 & A3), and sort how many times did "tom" play rank 1 or 2 or 3 before the fill date(F2).

    3.png
    Attached Files Attached Files
    Last edited by curly7777; 01-17-2018 at 08:00 AM.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: some questions about sorting with multi conditions

    Pictures are useless. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
    Include in the attachment any code you're currently using (whether it works or not) and an After of what you wish the output to be.

    In attached Excel file try not use:
    • merged cells
    • unnecessary formatting like: colours, borders, aligning another than default, etc...
    • unnecessary zoom
    You have words to logically describe the problem

    To attach an Excel file to your post,
    • desensitize data
    • remeber that your example should reflect structure and type of data
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

  3. #3
    Registered User
    Join Date
    01-16-2018
    Location
    taiwan
    MS-Off Ver
    2010
    Posts
    19

    Re: some questions about sorting with multi conditions

    thanks for your information
    please check the attachment above

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,268

    Re: some questions about sorting with multi conditions

    Try the following array entered formula* in I2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    *Select cell I2,
    Paste the formula into the formula bar,
    Simultaneously press the Ctrl, Shift and Enter keys.
    Try the following formula in J2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Edit: another way to get the value in J2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    To add more versatility put the track in K1 (i.e. A for A, A2 or A3 and B for B or B2) and use the following formula in J2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Last edited by JeteMc; 01-18-2018 at 01:21 PM. Reason: Added Edit
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Questions on Automatically sorting
    By naccoachbob in forum Excel General
    Replies: 5
    Last Post: 07-12-2017, 05:49 AM
  2. Sorting MCQ questions alphabetically
    By kokoman789 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-08-2013, 06:26 PM
  3. Excel 2007 : sorting questions
    By dnusz in forum Excel General
    Replies: 16
    Last Post: 04-05-2012, 09:09 AM
  4. sum with multi conditions
    By sheryar in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 09-02-2009, 01:02 PM
  5. Sorting + Misc questions
    By mgm123 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-04-2008, 10:33 AM
  6. Hopefully simple IF questions about conditions
    By Hodged in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-20-2006, 05:59 AM
  7. Table sorting questions
    By Bri in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-21-2006, 03:35 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