Hi guys,
I have a spreadsheet which I want to sort by maximum value in particular column I did a custom sort with largest to smaller, but the problem is some values are similar see in the attached picture. so basically what I want is to sort values in column 'N' with Maximum but if the values are repeating then if value in column 'p' is smaller then it should come above. for example in picture.
2. Aifaz Mukadam 3 / 29
3. Dadeesh 3 / 6
so dadeesh and Aifaz have same value in column 'N' but dadeesh have lower score in 'P' so dadeesh should come up.
please help guys
thanks.
Sorting_help1.JPG
Bookmarks