some questions about sorting with multi conditions

[curly7777]

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

[sandy666]

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

[curly7777]

thanks for your information
please check the attachment above

[JeteMc]

Try the following array entered formula* in I2:

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:

Please Login or Register  to view this content.

Edit: another way to get the value in J2:

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:

Please Login or Register  to view this content.

Let us know if you have any questions.