MS ACCESS Ranking 0-5 - TechRepublic
General discussion
November 22, 2010 at 05:48 PM
mikevla

MS ACCESS Ranking 0-5

by mikevla . Updated 15 years, 7 months ago

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

This discussion is locked

All Comments