Forum Discussion
Didier67
Jun 20, 2023Copper Contributor
Extract text cells if matches one or two criteria
Hello, first of all, sorry for my english and sorry i can't put photos here (don't know why but does'nt work)... 1. I did a template (date base) in wich each office will add their goals on each ...
SnowMan55
Jun 20, 2023Bronze Contributor
Didier67 See the attached workbook for a solution as I understand your request.
As the selection can be made using Office and/or Priority Type, there are three separate FILTER functions within nested IF functions. I created most formulas with a limit of 1,000 entries on the Combined Data worksheet, but that limit can be readily increased.
(You did not include much sample data, so don't be surprised at what I came up with. 😀 )