Ranking order based on highest to lowest value

**Pranuvins** · 07-29-2016, 01:31 AM

I have 25 products listed from H3 to H27 in sheet1. For those each 25 products I have last 12 months sale details from column I3 to T27 which will be pulled from sheet2 using vlookup. In I2 to T2 i have listed those 12 months name using a formula.

Now on column U3 to U27 I need rating for all those 25 products for each month. I have a dropdown on A1 which will get months from cell I2 to T2. Once I click a month for example Jun-16 I need to update rating for all the 25 products for that particular month on column U. Rating should be from highest to lowest (Eg. if maximum sale is 150 it should be Ranked 1 if 10 is the least sales it should be Ranked 25.

Please suggest any formula to resolve my issue. Thanks!!

**Pranuvins** · 07-29-2016, 02:39 AM

If you required any additional information. Pls do let me know

**AliGW** · 07-29-2016, 03:00 AM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**Pranuvins** · 07-29-2016, 04:10 AM

Hi AliGW,

As you said I have demonstrated my need in a sample excel which is attached here. Check and let me know.

Thanks for your time and guidance.