Audra Breedlove
asked on
Unique values per date
Hello,
I need a quick and easy way to determine the an individual's salary change and the date the change was made.
The data below, show the annual salary each salary makes, per pay check. At some poing the salary changes due to an adjustment promotion, extra.
Employee 1 has 18 pay periods. I only need to see the check effect date and pay for the starting salary and when the salary changed.
Data return
Employee Salary eff Pay
1 12-19-11 6,227.01
1 3-12-12 6,444.95
Unique-Salary-values.xlsx
I need a quick and easy way to determine the an individual's salary change and the date the change was made.
The data below, show the annual salary each salary makes, per pay check. At some poing the salary changes due to an adjustment promotion, extra.
Employee 1 has 18 pay periods. I only need to see the check effect date and pay for the starting salary and when the salary changed.
Data return
Employee Salary eff Pay
1 12-19-11 6,227.01
1 3-12-12 6,444.95
Unique-Salary-values.xlsx
ASKER
I like this method, but I'm looking for something a little easier. I have to refresh this data quite often and I was hoping for a little quick formula that I hadn't thought of.
Though maybe not frequent, I would assume that an employee's salary could change multiple times in a given year (e.g., promotion, transfer, demotion, annual review, etc.). How would you want multiple occurrences to be handled?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Copy-of-Unique-Salary-values.xlsx