Jan 31 2024 04:12 PM
Hi everyone!
I am creating a task priority matrix in Excel and am stumped on the exact formula I need to accomplish what I am looking for.
Column R is where I enter daily tasks, and Columns T & U each have a dropdown menu with two options - "High" or "Low". My Matrix has 4 quadrants and I would like the tasks to auto-fill in the appropriate quadrant depending on the selections for Columns T & U (High/High; High/Low; Low/Low; Low/High).
I need to make sure that if I enter a task in, for example, cell R18, it will carry over to the next available field in the appropriate quadrant, for example, cell C4.
My Table runs from rows 5 to 35, and the Matrix is a rectangle made up of 4 rectangles - 2 upper and 2 lower). Quadrant 1 = c4 to i4 / Rows 4-19; Quadrant 2 = J4 to P4 / Rows 4-19; Quadrant 3 = c20 to i20 / Rows 20 to 35; Quadrant 4 = J20 to P20 / Rows 20 to 35.
Looking for any advice! Thank you!
Jan 31 2024 06:25 PM
SolutionFeb 01 2024 07:32 AM - edited Feb 01 2024 08:02 AM
I just tried it and IT WORKS!!!!! Thank you very much for replying and giving me my sanity back lol.. I spent hours trying to figure this out..
Alternatively, if I only had one criteria, how would the formula change?
Feb 01 2024 09:31 AM
Feb 13 2024 12:29 PM - edited Feb 13 2024 12:31 PM
Thank you for being so helpful. I wish I had your Excel skill level! :)
I have one more ask: I changed the matrix a bit and will require a list based on two criteria, but a little different than the scenario above. One criteria will be the priority level (Low, Medium, High, Critical) and the other will be product type (Auto, Farm) where I would like it to add text in addition to the text written in the table.
Let's say I enter "Create fleet presentation", and the criteria I choose is "High", and then "Auto". I would like it to appear in the matrix as, "Create fleet presentation - Auto", in the High Priority box. I hope that makes sense! If not, I will certainly clarify for you.
Thank you in advance. :)
Feb 13 2024 04:06 PM
Feb 13 2024 09:12 PM
Please see attached.. What you will see is that the data I enter under the table shows up in the matrix depending on priority status (First criteria). And the second criteria ("Auto" or "Farm" from dropdown list) shows up in brackets after main text.
Example: Go to grocery store (Farm).
Feb 14 2024 04:53 AM
Jan 31 2024 06:25 PM
Solution