# Excel Ranking with multiple conditions

1. ## Excel Ranking with multiple conditions

Hi,

I have an excel file with the attached format. Now i want to put rank for the event. Here I am manually put the rank (rank 1 Only) on the last field.

THanks

2. ## Re: Excel Ranking with multiple conditions

g3
=SUMPRODUCT(--(\$C\$3:\$C\$23=C3),--(\$E\$3:\$E\$23=E3),--(\$F\$3:\$F\$23<F3))+1 filled down

3. ## Re: Excel Ranking with multiple conditions

Hi Martin,

Please find the attached master file. It was mismatched with your formula. Kindly check and let me know asap.

Regards
Ahamed

Originally Posted by happyahamed
Hi,

I have an excel file with the attached format. Now i want to put rank for the event. Here I am manually put the rank (rank 1 Only) on the last field.

THanks

4. ## Re: Excel Ranking with multiple conditions

=(SUMPRODUCT((\$C\$3:\$C\$166=C3)*(\$F\$3:\$F\$166>F3))+1)+COUNTIFS(\$F\$3:F3,F3,\$C\$3:\$C3,C3)-1

Azumi

5. ## Re: Excel Ranking with multiple conditions

Thank you so much.

6. ## Re: Excel Ranking with multiple conditions

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -

Incase your issue is not solved, you can undo it as follows -

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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