exceluser4
New Member
- Joined
- Mar 19, 2012
- Messages
- 12
If the grade name in Column A equals the grade name in Column E then I want it to take the Salary in Column B and divide it by the Grade Mid in Column G. The way I have the formula, which is wrong, works only if the data is all on the same row. But as you can see the data in Column A will not always be on the same row. Any help would be greatly appreciated. Thanks so much!
<TBODY> </TBODY>
Column A Grade Name: | Column B Salary | Column C New comp | Column E Grade Name: | Column F Grade Min: | Column G Grade Mid: | Column H Grade Max: | |
E06 | 30,000.00 | 80% | E06 | 29,910.00 | 37,387.00 | 44,865.00 | |
E07 | 39,000.00 | 96% | E07 | 32,624.00 | 40,780.00 | 48,936.00 | |
E08 | 32,000.00 | 72% | E08 | 35,621.00 | 44,526.00 | 53,431.00 | |
E09 | 49,000.00 | 101% | E09 | 38,890.00 | 48,613.00 | 58,336.00 | |
E10 | 44,000.00 | 83% | E10 | 42,466.00 | 53,083.00 | 63,700.00 | |
E11 | 50,000.00 | 86% | E11 | 46,377.00 | 57,971.00 | 69,565.00 | |
E12 | 60,000.00 | 95% | E12 | 50,632.00 | 63,290.00 | 75,948.00 | |
H10 | 10.00 | FALSE | H07 | 9.87 | 11.61 | 13.35 | |
H09 | 9.50 | FALSE | H08 | 9.13 | 10.75 | 12.36 | |
H08 | 9.50 | FALSE | H09 | 8.45 | 9.95 | 11.44 | |
H07 | 8.50 | FALSE | H10 | 7.82 | 9.20 | 10.58 | |
H11 | 7.25 | 8.51 | 9.77 | ||||
H12 | 7.25 | 8.15 | 9.05 |
<TBODY> </TBODY>