Unable to RANK from Lowest Amount When the Item Is Only One
I hope you're all doing well.
I have this problem that's preventing me from proceeding on to the next steps.
I'm trying to rank the basic salary from lowest to highest, by position.
As we all know, even if employees have the same position, there are instances that they don't have the same salary.
The idea is, I need to get the lowest salary per position.
The issue I'm encountering is that, if I do a rank formula, it does return the correct order when there are more than 1 employees.
But if the position is assigned to only 1 employee, meaning only 1 employee has that position, it always returns 2. I need the value to be 1 since that will be my basis of getting the salary amount: IF Rank = 1 THEN Basic Salary ELSE 0.
Thank you for all the inputs you may share.