I Have a marksheet bearing student's name and marks as data
Now what i have done is
I used =sum formula for total
then =rank formula for rank
after that sorted the data I columnwise
But now if again i add a student's name and marks then again i have to sort the data for getting their rankwise place
so i want excel magic in such a way that if i enter other students' names their names marks total everything must be displayed in the row as per their rank
plz help me
Change your worksheet to an .xlsm type
Enter this vba in the worksheet change event for the sheet.
Do not put it in a standard module
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi Refer the attachmet
☚ Click ★ just below left if it helps, Boo?ath?
Quite helpful
thanks a lot
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
This is my take on a solution for you.
The ranking column formula has been modified to take care of tied scores. I also used Index, Match, Small to determine the sort order.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thats what exactly i wanted
overwhelmed with thanks
Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks