How to setup access to Rank

[TJVFree]

I’m trying to put my customers in Rank from 0-5 depending on the past 3 months, 6 months, 9 months, and 1 year.

The numbers I used below are only sample numbers. If it doesn’t make sense please email me and I will get back to you right away.

Thank you for taking the time to help with this query

Customer Name
3M/ 6M/ 9M/ 12M/ Rate between 0 and 5
Joe Smith 123/ 102/ 145/ 201/ 3.1
Jan Smith 223/ 302/ 241/ 225 4.2

Below are some of the formulas I used in MS Excel.

=1-((C6-1)/SUM($D$4:$D$2002))

=5-(AJ5/MAX($AJ$3:$AJ$10000)*5)

 

[MajP]

The first method does exactly that. Do you have a specific question?

 

[TJVFree]

Thank you, thanks you, thank you and thank you “Rebecca, TheAceMan1, Duane, dhookom, MajP”

Thank you all for taking the time to help with this issue. I haven’t been on this sight for help in along time, but this sight and the people helping ROCK…..Thanks again

Corey