Hi,
i want to add into named range from dynamic table where Criteria is "Yes" or "No".
So for named range = "ResultNo" i should have array : {1111,2222,3333} and for named range = "ResultYes" i should have : {4444,5555,6666,7777} in Formulas Manager from dynamic table.
How can i achive this in the simplest way?
Best,
Jacek
Screenshot_16.png
Bookmarks