The end result I am trying to achieve is that I would like to suppress any rows that do not contain the maximum effective date for each employee.

From what I understand, I could achieve this in three steps (although there may be an easier way)

step 1: write a formula identifing the row containing the maximum effective date for each employee

step 2: write an if statement saying that if the effective date is equal to the formula in step 1 then keep, otherwise ignore

step 3: suppress all rows where step 2 = ignore

Could someone please advise how I would write the formulas to achieve the above, or if there is a better way to do it.

Thanks, Ruth