Macro to sort data in a clolunm if specific text is in another colunm

[petitesouris]

Hello

I have been able to sort out my data and get what I want except when it comes to be able to sort the value of the total value....

I will upload a sample so you can understand what I need

In that example I have the data sorted by student name then marker - I have to do that in order to have the data with student name and the order of the marker to finish with the total

It is organizing nicely my data the way I want it once I have downloaded that from our CRM -

but for work purpose I need to see the student with their marker Total by value that is the highest.... I don't care at the end if students are not in alphabetical order but the last line of a ecord for a student as to be total

I tried sorting and of course it does messup because I have different value for marker :-)

Thank you for your help

[zbor]

Use Pivot table with filtered Total value.
Or delete total value from a first table if possible.

[petitesouris]

Hi Thanks I actually used a pivot table and got that too but it does not do what I want I want to be able to see

As I need to look after students who have a high total and see what their total is made off

But thank you

Aaron Trom to come at the top of my list because the total of Aaron is 75
then it should be aaron Rain
then Celine
thern the bartender

[petitesouris]

Hi it seems it worked just applied a filter thanks will explore a bit more with more data and will post back!!!! Thank you so much

[petitesouris]

Hi Thank you but after checking it did not work as in the pivot table it gives me the sum of all the value

The total marker with the value attached to it is already the sum of all the over marker and in the pivot table it is giving me the sum of everything so does not do the job :-( I still need to be able to sort
Thanks a lot for your help

[petitesouris]

Hi Thank you I actually deleted total value but because we apply a multiplier the total value can differ from the sum of the markers therefore I need to sort on that Value. I tried the option of deleting sub total and value and it is not 100% accurate. this is why I thought about a macro rather than my usual tricks of pivot table and filtering :-)

[zbor]

Can you upload example where you get different result and what you expect?

[petitesouris]

abpove there is a sample in excel of what I need thank you