Hello, I have been able to find parts of what I need but couldn't make them work properly together. I am by no means any expert in Excel and tbh what I have so far is from internet. I frankly don`t understand more than half of what these formulas state but some of them work just as intended. This may be one of those things that cannot be done and if so, I would appreciate much if you help me realise that.
However, better would be if anyone can help with a solution.
I hope the images will suffice in showcasing the concept I'm trying to pull off.
Where I got stuck. Please find formulas below as well.
Can anyone make the last array formula return all the matching Tasks properly and integrate the percentage criteria in both arrays? Feel free to use helper columns. Ideally w/o VBA.
Thank you very much!
However, better would be if anyone can help with a solution.
I hope the images will suffice in showcasing the concept I'm trying to pull off.
Desired Outcome
(everything has been edited manually to showcase)
First picture explains the concept and the second is a complete scenario.
(everything has been edited manually to showcase)
First picture explains the concept and the second is a complete scenario.
Where I got stuck. Please find formulas below as well.
COUNTIF($B$2:$E$5;H2) |
{INDEX($H$2:$H$5;MATCH(1;SIGN(COUNTIF($K1:K$1;$H$2:$H$5)<SUMIF($H$2:$H$5;$H$2:$H$5;$I$2:$I$5));0))} |
{INDEX($A$2:$A$5;MATCH(1;MMULT(--($B$2:$E$5=K2);TRANSPOSE(COLUMN($B$2:$E$5)^0));0))} |
Can anyone make the last array formula return all the matching Tasks properly and integrate the percentage criteria in both arrays? Feel free to use helper columns. Ideally w/o VBA.
Thank you very much!