ranking multiple columns

Good Morning Any ideas on how to do this in a measure.... Create a Ranking based upon a date from Earliest to Latest, where SALES DATE is Grouped and Machine is grouped. My Data looks something like this, but continues for upto 42 days and involves some 30 other fields in the table but...

Hello, I am trying to find a way to rank the items in the below table by quarter from earliest to latest and then by month from earliest to latest after quarter in excel 2003. When I use the below sumproduct formula, it only ranks the months for each quarter but doesn't rank the quarters...

Good day i am administering a competition in excel. the participants are split per region and each one has a sales figure and sales target. basically if you make your target, you get a prize. however the salesman with the highest value above target per region will get ad additional prize if...

I need help on unique ranking based on multiple criteria. I've been asked to rank 10 employees based on the following criteria: BA %, FA %, Outstanding FA% and Uncontacted %. <tbody> A B C D E Name BA % <tbody> FA % </tbody> Outstanding FA% Uncontacted % </tbody> How do I go about...

I am having trouble ranking my data in Excel based on 2 columns. The 2 columns are CYCLE and DURATION. The ranking should work like this: It should rank CYCLE first then DURATION second. The formula should work even if the data is not sorted or with blanks. For instance, here is my sample...