Hello people,
I need help with making positions I mean 1st, 2nd, 3rd….positions.
On the attached table, there are 3 percentages i.e column G,J,M. and the 3 percentages are the 3 criterion for the position. In essence, The school with the highest percentage in the 3 column comes 1st and so on.
Please assist me in making it work.
Thanks All.
So what would a sample answer look like?
1st, I suggest you change the formulas in G (etc) to something like this,,,
=IFERROR(F2/D2*100,"")
this will eliminate the errors
If you want the largest of that column...
=LARGE($G$2:$G$21,1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@FDibbins what you are saying in essence is that the position we want can only be based on one of the percentages instead of the 3? that is G for instance?
you could work something for me in the sheet and upload so i can have a clear picture of your solution.
No, I was asking you to show me samples of what you expect the answer to look like, so that it is clear to me what you want.@FDibbins what you are saying in essence is that the position...
This was just to eliminate the errors you are showing, which will make any other calcs easier1st, I suggest you change the formulas in G (etc) to something like this,,,
=IFERROR(F2/D2*100,"")
this will eliminate the errors
@FDibbins, thanks for your support. attached is the expected result, and for the schools that are yet to be populated, as soon as they are populated, they should automatically find their position.test 22.xlsxtest 22.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks