Detecting Highest to Lowest..

[hgbegdhegdh]

I have some numbers from CELL H8 to H12

I WANT that in CELL I8 to I12 I want to rank Highest Number as 5, 2nd Highest as 4, 3rd Highest as 3, 2nd Highest as 2 and Lowest as 1

Attached EXCEL File.

In Sheet 1 SAMPLE data is there

In the attached sample, in CELL I10 5 will come, in I11 4 will come, in I9 3 will come, I12 2 will come, I8 1 will come

Its easy for you people, but hard for me.

Please Help

You can download SAMPLE file here

ranking data.xlsx - Shared with pCloud

Keep all your documents safe, access them on any device you own and share with just the right people. Create a free pCloud account!

my.pcloud.com

 

[Fluff]

How about
=RANK.EQ(H8,$H$8:$H$12,1)

 

[hgbegdhegdh]

How about
=RANK.EQ(H8,$H$8:$H$12,1)

Not working. This shows 1 in each cell. Attached screenshots

 

[Peter_SSs]

Not working. This shows 1 in each cell.

Go to File -> Options -> Formulas and make sure that you have Calculation options set to 'Automatic' not 'Manual'.

I also suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[hgbegdhegdh]

Go to File -> Options -> Formulas and make sure that you have Calculation options set to 'Automatic' not 'Manual'.

I also suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Problem solved. Actually problem was I copy pasted formula from here ( website ) to all 5 cells that's why it was H8 in all cells. Now i pasted in H8 and then copied this H8 cell to rest other place. Problem solved

THANK YOU FOR EVERYBODIES HELP.

 

[hgbegdhegdh]

Not working. This shows 1 in each cell. Attached screenshots

I also updated details in profile

ONCE AGAIN MR.EXCEL SOLVED MY PROBLEM.THANKS TO ALL HELPERS.

 

[Peter_SSs]

I also updated details in profile

Thanks for doing that.

Glad you worked out what the problem was.