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.
Bookmarks