I’m OK with Excel, but never tried a formula like this before.
I’m trying to create a Things to Do/ Time Management spreadsheet that will do the following. (See Picture) (It turns out the picture is kind of wide and you may have to right click and go to the URL to view the whole thing, Sorry!!)
The picture is a capture/crop of 2 tabs. Tab A is the things to do list with colums labeled
Priority (Values 1-9)
Sequence (values A-D)
Item (Text of “things to do”)
Urgent (This will be Y or N for Yes or No)
Value (This will be H or L for High or Low)
Now look at the right hand side of the attached picture, which is Tab B
The 4 quadrants correlate to the “Urgent” and “Value” columns in Tab A
What I would like to have it do is first:
Disregard anything that is not marked priority 1 on tab A since I will only be using tab B for DAILY to do items and I will be using tab A for an all inclusive, on-going to do list.. (Also, disregard Sequence values for now…)
Have it split up all remaining priority one items into each quadrant by its assigned “Urgency” & “Value” values with no blank spaces in between.
Green Quadrant is Urgency Y and Value H
Yellow Quadrant is Urgency Y and Value L
Lt Yellow Quadrant is Urgency L and Value H
Red Quadrant is Urgency L and Value L
Then, If possible, I’d like to have it list them in order of the value listed in “Seq” column on the Tab A.
I hope that with the picture and this text, I was able to make things understandable. Any ideas on how to get this done? Also, If I get this done and anyone runs across this and wants a copy of the spreadsheet, just drop me a line. This method came highly regarded in a audio CD by a time management specialist and seems to be “doable”.
Self
