Forum Discussion
Help with Formula
You are welcome. The formula in column R refers to 2170 rows and the formula in column U refers to 9 rows. The screenshot shows 9 rows therefore it's impossible to tell why there are different results. I could only guess why the results are different. Can you attach your file without sensitive data so we can have a look at this?
OliverScheurich It's most likely because the reference number is not unique by employee, but rather represents the pay period cutoff date, or something like that, where it will be the same reference number for all employees for the pay period. As you've stated, this is just a guess, but I'd be willing to bet on it, lol. Additional criteria for the first and last name columns is likely needed to find the unique "Salary" record for each employee...
