Thank you for taking the time to read/help me with this query question.
I have a list of data that goes back 9 months. What I?m looking to do is put them in a grouping such as ?3 Months? 6 Months? and ?9 Months? and maybe a total of all with its not to hard to do. Then once that is done I would like to Rank then either by the past 3 months or even back 1 year.
The formula in excel looks like this =5-(AJ3/MAX($AJ$3:$AJ$10000)*5)
Thank you once again for your time and help