According to the attached table, the rank has been found according to Achieved %, in which some salesman does not have target.
The data in this table should come in a new table according to rank order eg:- 1 ,2 ,3 etc ..... .Without target Salesman's Data Should Came Last Rank Data. Below Line Wise .Need formula to arrange Rank Wise Sales Man Data In NEW Table