Fastest way to get most recent salary
Posted on 2012-03-23
I have a table with records (rows) that contain the following fields (columns):
The table lists a new record for an employee whenever his/her salary changes.
I'm trying to get the salary (e.g. column b) for the most recent (max) date of each employee. once I have list with only the unique values for the employees, how would I get the salary figure?
I think I would use an array formula, but I'm stuck.