I have a complex calculation I’m trying to do. I have a table of employment history for many people. Columns include:
- person’s name
- date started
- salary rate
A person may appear multiple times in the table if they’ve gone through multiple job positions.
What I’m trying to figure out is, how many people saw an increase in their pay with a newer job. Is there a way to do this sort of comparison effectively? I know how to manually do this in Excel, using various sorting and formulas. But I’d like to automatically filter and count those instances.