General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
MS ACCESS Ranking 0-5
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