Autosum with condition

[impala096]

I have a list of employees in Column A that I would like to sort by the total number of OT hours worked in Column B so the person with the lowest OT is the first one to be called.

Sample Data:

Column A Column B Column C

Employee OT Hours Call Order
Adam 3 2
Steve 8 3
John 2 1
Chris 7 4

Autosort would work perfectly for what I am trying to accomplish except there is one condition that needs to be met. Regardless of how many OT hours Steve has worked, he must always be the 3rd person to be called. I figured I would need to create a Column C for autosort to reference but I don’t know how to replicate the results of Column C in a formula.

Thanks for any suggestions.

[Portuga]

You can use the "Sort" to sort "first by" column C and "then by" column B (you can sort by multiple columns).

If you want to exclude anything thats not "3" in order, you can apply an autofilter to your data and then do the sort by column B only