rank excel

I have lost hope of me being able to work this one out, although sure easy for you all I am trying to rank each product individually by date in excel, so effectively each product in the list will have its own rank by date. For example Tomato Sauce rank 1, 2, 3, 4 etc. Black Bean CPU rank 1...

Hi All, I am looking to get a rank column as shown below using some rank functions. We have to group all same locations and rank within the group. Then, the lowest sales should get the first rank. If the sales are same, the rank should be given based on the second Column Amount. For example...

Hello, I just finished doing assessments for my 37 Athletes and now for my assessment report my team leader wants me to make each criteria worth the same amount of points as the percentage it represents. For example Jumps are worth 20% and I have 22 boys and 15 girls so I want to allocate a...

Hello, I am looking to fix my formula or understand a better formula to rank titles in one column where the title can appear multiple times with different number of units each time the title appears. Below is an example (Note I only included the rank in column C without the name of the title...

I have a spreadsheet where column A has the company ticker, Column B the name, and Column C has their stock's change in performance. There are a total of 1000 rows of data, column C can sometimes be the same, for example two stocks could increase by 5%. Out of the 1000 companies I only care...

Can anyone help me with how to break a ranking tie using standard deviation? 10 people rank their choices from 1-10 (10 being best), so I started with a plain basic rank based on the sum of all 10 people's choices. Highest overall number represents the groups most favorite choice. I would like...

Hi, I don't know if this can be done in without VBA. I want to rank (descending) values in a column. That could be easily done with the RANK formula, however if there are ties the value after the rank tie will take into consideration the number of tied values and add it to to get the order of...