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
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