Excel Formula
1.According to the table, the rank has been found according to Achieved %,
2.According to the rank and according to the ascending order, the data should also come to the 2nd sheet through the formula
3.In this some Salesman has Achieved Amount but Target Zero. This Salesman Data. The last ranked Salesman should come in the line next to the data.
4.Similarly, some salesman has a target but no achieved amount and that should be taken as a basis
5.From this Data table only Salesman data with achieved amount and target should come to the answer table according to the above criteria.
This all Criteria Should Came In a Single Excel Formula.
1.According to the table, the rank has been found according to Achieved %,
2.According to the rank and according to the ascending order, the data should also come to the 2nd sheet through the formula
3.In this some Salesman has Achieved Amount but Target Zero. This Salesman Data. The last ranked Salesman should come in the line next to the data.
4.Similarly, some salesman has a target but no achieved amount and that should be taken as a basis
5.From this Data table only Salesman data with achieved amount and target should come to the answer table according to the above criteria.
This all Criteria Should Came In a Single Excel Formula.
