ABC Analysis "How to create a formula to letter rank cells based on percentages"

I need a formula in column "F" that automaticly determines the ABC Ranking based on the following percentages from column "E"

From the top down...

A=the first 80%
B=the next 14%
C=the next 4%
D=the next 1%
DEAD=all 0%

Basicly the top 80% needs to display "A"
the next 14% should display "B" then 4% "C" and so on...

I have attached a file where I manually entered the Ranking in column "F" to display the desired results. Column

Perhaps this in F2 and filled down

=LOOKUP(PERCENTRANK($D$2:$D$48,D2),{0,0.01,0.04,0.14,0.8},{"Dead","D","C","B","A"})

Try this in F2 and copy down. Workbook attached.

Formula:

Please Login or Register  to view this content.

Works! Thank you!