Need assistance with complex ranking / prioritizing formulas

MrGNM

New Member
Joined
Apr 11, 2012
Messages
19
Hello and thank you in advance if you are able to assist me with this project. I initiated it several years ago as a spreadsheet solution to help with my ADHD. It's supposed to take a list of items and rank them in order of priority based on a number of factors.

The project was never completed, got put on the back burner and is often the case with me, just faded away as I got involved with other things. But this is actually important and I would benefit greatly by having a working version, so I'm revisiting it in the hopes that someone can make the necessary corrections to the formulas so that it works properly.

The issue is that it's not ranking properly and that when an item is closed, it's not removing the item and re-ranking the remaining items.

Please email me directly at gnm9143@gmail.com for a copy of the spreadsheet. Please post or message any specific questions you have. Thank you again.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Hello and thank you in advance if you are able to assist me with this project. I initiated it several years ago as a spreadsheet solution to help with my ADHD. It's supposed to take a list of items and rank them in order of priority based on a number of factors.

The project was never completed, got put on the back burner and is often the case with me, just faded away as I got involved with other things. But this is actually important and I would benefit greatly by having a working version, so I'm revisiting it in the hopes that someone can make the necessary corrections to the formulas so that it works properly.

The issue is that it's not ranking properly and that when an item is closed, it's not removing the item and re-ranking the remaining items.

Please email me directly at gnm9143@gmail.com for a copy of the spreadsheet. Please post or message any specific questions you have. Thank you again.

Sorry, but several years ago!
 
Upvote 0
Is that a question, or are you simply mocking the fact that this was started several years ago and never finished?
 
Upvote 0

Forum statistics

Threads
1,215,327
Messages
6,124,292
Members
449,149
Latest member
mwdbActuary

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top