Hi,
I am trying to use index and match formulas to determine the salary percentile in table 1 in the attached excel file. I need to match the person's group and position name in Table 1 to those in Table 2 and then determine the closest percentile to that person's salary.
For example: Joe an analyst in red group makes 37,000. The correct return in table 1 would be the 12th percentile. If Joe made $38,000, the percentile would be 13. If he made in between the 12th and 13th percentile at 37,500, the formula should return the higher percentile 13.
Any help on this is greatly appreciated! Thanks in advance!
Bookmarks