Process of Elimination using criteria

[DAD]

Hi All,

I am trying to find a result by search multiple columns of a table. For example, see the table below. I wish to search the employees and firstly find the youngest employee (Col C). If there are multiple employees with the same age, I then seek to further narrow those employees with the youngest age to find the one with the highest salary (Col D). If multiple employees have the same age and same salary, I seek to differentiate those employees based on their seniority date, with the most senior (earliest joint date) being the decider.

In this example, Mike, Pete and Steve have the same age, so I compare their salaries, Pete is eliminated as his salary is lower than Mike and Steve. But as Mike and Steve share the same age, and the same salary, I look at their seniority date, and as Mike joined first, he is the winner.

I have tried numerous methods but can't seem to get it to work. I can't use VBA or macros for this spreadsheet. Any ideas would be greatly appreciated

 

[Michael M]

So why not use a Custom sort.....it's on the editing tab under sort and filter.
You can sort by each level as you have described

 

[DAD]

Hi Michael,

Thanks for the reply. Unfortunately the Custom Sort does not work as I need the list to update dynamically as the list changes. Well at least I think that is how the sort function works. If it does update dynamically, I would be most interested to hear how to do that.

 

[Michael M]

To update a sort function automatically, you would need to use VBA !

 

[DAD]

Hi Michael,

Ah, I feared as much. As this will be deployed on iPad, I am unable to use VBA or Macro.

Thanks for your help anyway

 

[Michael M]

Hmm... the joys of being an Apple owner...:wink: