Forum Discussion
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 priority types.
Example (here are the three columns):
SELECT OFFICE, SELECT PRIORITY TYPE, ADD GOALS
QUEBEC RECRUITMENT COMPLETE 3 PROMOTING CAREER ACTIVITIES
2. On the second page, i want to select wich of the office and wich of priority type (lists are already done) and be able to extract each goals in a list. Like if the boss want to see wich goals ar per office or priority type, on a list.
What formula can i use to extract all goals from priority type and or offices ?
Thank you very much community.
Pier-Olivier
1 Reply
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. 😀 )
