Solved

rank minimum order

Posted on 2016-10-20
9
23 Views
Last Modified: 2016-10-20
Hi,
I would like to rank values by minimum order on EventID
Please see attached sheet.
Many Thanks
Ian
Rank-min-order.xlsx
0
Comment
Question by:racepro
  • 3
  • 3
  • 3
9 Comments
 
LVL 5

Expert Comment

by:Austin Texas
Comment Utility
I read your request and I am looking at your document but I am still scratching my head.

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

by:racepro
Comment Utility
AFTER....I have manually entered the values I require the formula to determine.
please check spreadsheet values in column D
0
 
LVL 5

Expert Comment

by:Austin Texas
Comment Utility
Okay, that helps. Can you show me what it looks like before?
0
 

Author Comment

by:racepro
Comment Utility
???????  column D is blank before ???????
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 28

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 500 total points
Comment Utility
Try this...
In D2
=SUMPRODUCT(($A$2:$A$29=A2)*($C$2:$C$29<C2))+1

Open in new window

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

by:racepro
Comment Utility
Perfect. Thanks again Neeraj
Ian
0
 
LVL 28

Expert Comment

by:Subodh Tiwari (Neeraj)
Comment Utility
You're welcome Ian. Glad to help. :)
0
 
LVL 5

Expert Comment

by:Austin Texas
Comment Utility
Yes, thanks Neeraj!  I was not getting it! :]
0
 
LVL 28

Expert Comment

by:Subodh Tiwari (Neeraj)
Comment Utility
You're welcome Tex!
Never mind, it happens sometimes when it is hard to visualize the end result.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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 …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now