I put together an advanced filter to only show rows that match my selection from a drop-down menu. I used function =IF(E6=“”,”*”,E6) and recorded a macro to extract data from one sheet and display in my filtered table on another sheet. It works well, but I’ve run into a wall.
I have some cells with multiple text values. For example, under header “Provinces” I have some cells with “Ontario, Quebec, Alberta” because this row applies to 3 provinces. Using my filter, I can find this row by searching for Ontario because it is at the beginning of the string. However, if I select Quebec or Alberta this row is ommited. How can I tweak my formula to search for the text regardless of its position in the cell?
I have some cells with multiple text values. For example, under header “Provinces” I have some cells with “Ontario, Quebec, Alberta” because this row applies to 3 provinces. Using my filter, I can find this row by searching for Ontario because it is at the beginning of the string. However, if I select Quebec or Alberta this row is ommited. How can I tweak my formula to search for the text regardless of its position in the cell?