Formula Help Intervals

[Lyaliuae]

Hello,

First of all, thank you very much for the help that you always provide.

And I really learnt a lot from this sharing forum, and I gained enough experience in some aspects to do my work.


However, I need some help with my excel. I tried to use those 2 methods to overcome the issue that I am facing.

Please look at the attached file.

If you open the method 1 tab, you will see that I am trying to do intervals solution to make the results of all to be 100 in column F. But what I am facing is some names have the same average, but they get a different result for example, A12, A11 Names their Average is 14, but the results are getting are different. So, what I mean is I want the same average in Column E get the same results of Intervals in Column F, If you can help to tweak it, to read correctly.

In method 2, I am trying to do it, but with the median. However, in Colum I = or above the median method close/far to the median worked well, but below the median wasn't read correctly it must be from 0 to 47, but it read it from 29 to 47

So, all I want is the same result for the ones that have the same average, and it can be done from 0 to 100

Any help will be appreciated, thank you.

[amit.wilson]

In the Median method, you could try this formula in G4 and copy it down

Please Login or Register  to view this content.

Cheers

[Lyaliuae]

In the Median method, you could try this formula in G4 and copy it down

Please Login or Register  to view this content.

Cheers

It worked, thank you very much amit.wilson!

Much appreciated.

[amit.wilson]

That's great! Good luck with the sheet.

Cheers


BTW could you mark the thread "Solved"?

To mark your thread solved do the following:
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved