Hi there

I am trying to create a command that will sort the names of people entered into order of most frequently occurring where there is a negative value in in a cell in the column above their name. I am trying to do this without having to link to a reference list of names as the variable number of names is around 80 possibilities.

So is like a mixture of an IF and an INDEX (?) command and if so how would I go about doing it? is it even possible?

TIA

Rachel