Solved

# rank minimum order

Posted on 2016-10-20
40 Views
Hi,
I would like to rank values by minimum order on EventID
Many Thanks
Ian
Rank-min-order.xlsx
0
Question by:racepro
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 3
• 3
• 3

LVL 5

Expert Comment

ID: 41852508

I don't understand what you mean by "rank values by minimum order on EventID".
Is that two conditions? Do you want to "rank values by minimum" and "order on EventID"?
Can tell me a little more?

Is the attachment an example of what you want it to look like before or after?
0

Author Comment

ID: 41852517
AFTER....I have manually entered the values I require the formula to determine.
0

LVL 5

Expert Comment

ID: 41852522
Okay, that helps. Can you show me what it looks like before?
0

Author Comment

ID: 41852526
???????  column D is blank before ???????
0

LVL 31

Accepted Solution

Subodh Tiwari (Neeraj) earned 500 total points
ID: 41852529
Try this...
In D2
``````=SUMPRODUCT((\$A\$2:\$A\$29=A2)*(\$C\$2:\$C\$29<C2))+1
``````
and copy down.

Note: In your file Calculation Options is set to Manual, please set it to Automatic to update the formulas after you copy it down.
0

Author Closing Comment

ID: 41852547
Perfect. Thanks again Neeraj
Ian
0

LVL 31

Expert Comment

ID: 41852550
You're welcome Ian. Glad to help. :)
0

LVL 5

Expert Comment

ID: 41852556
Yes, thanks Neeraj!  I was not getting it! :]
0

LVL 31

Expert Comment

ID: 41852562
You're welcome Tex!
Never mind, it happens sometimes when it is hard to visualize the end result.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
###### Suggested Courses
Course of the Month8 days, left to enroll