February 28, 2017
Since recently purchased Excel 2021, very happy with brilliant new features, FILTER FORMULA is massive time saver, producing small file size and very concise formula edits, but....
Question: Since FILTER FUNCTION is either AND or OR, is there a simpler/better way to express the following SEARCH RESULTS (See 1st TAB: SEARCH AZ K13-K17) for the 4 MULTI DEPENDENT COMBO BOXES? Seems a bit complicated/long for what it is.
File is attached, 1st TAB is SEARCH AZ with RESULTS the 4 Combo Boxes are in Cells , 2nd TAB is DATA with Formula to create data validation for combo boxes, and filter function 5 variations of the Combo Boxes Col D-A, Col C-A, Col B-A, Col A or BLANK.
Since FILTER FUNCTION is either AND / OR, so my approach might be the way, think better expressed as seperates SEARCH AZ Cells K13-K17 as much easier to follow/edit, instead of 1 long nested if as in SEARCH AZ Cell K23. But if there is simpler/better way, I'd be intrigued to learn of it!
July 16, 2010