Auto Rank and Sort Variables Number/Change

hi all,

needs your help in the attached file. based on the result i would like to auto rank them (using 1,2,3 etc) and then sort the item based on the rank - is this possible?

cheers

A1(anwser 1):
Sort table 1, descending by either Cost(#) or Cost(%). Rank 1 will alway be at the top and the last rank will always be at the bottom. In the Rank column I would use;

This puts in the 1,2,3,... sequence(if needed). I do not think you need a rank number because after sorting, rank 1 is always at the top and the last rank is at the bottom.
In cell J7 type =If(H7="","",1)
In cell J8(and downward) type =If(H8="","",J7+1)
In cell J9(and downward) type =If(H9="","",J8+1)

Sort descending is done by selecting cell G7(in this case) and from the Home tab, click on the Sort & Filter button and select 'Sort Largest to Smallest'.

thanks dennis7849, but it doesnt really solve the overall problem.

based on the data, what i am trying to do is to (1) identify the highest % [done] (2) based on the %, identify the top and bottom and rank them from 1 onwards - this need to be done automatically and not using the filter function (3) re-order the list based on item 2 - again without using the auto filter function.

the solution that i am looking for is to eliminate human interference (by using the auto filter), plus, the data that we received is on real-time basis ...

i have managed to get a workaround for this. will consider this as solved.