C carl May 20, 2004 #1 Can the advanced filter be set up to look at 2 columns and filter the data that contains a value in 1 OR the other column ?
Can the advanced filter be set up to look at 2 columns and filter the data that contains a value in 1 OR the other column ?
F Frank Kabel May 20, 2004 #2 Hi yes. Just use two defintion rows in your criteria range. The Excel helps outlines some examples for this. Also see: http://www.contextures.com/xladvfilter01.html http://www.contextures.com/xladvfilter02.html
Hi yes. Just use two defintion rows in your criteria range. The Excel helps outlines some examples for this. Also see: http://www.contextures.com/xladvfilter01.html http://www.contextures.com/xladvfilter02.html
