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)
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)