Forum Discussion
Pivot Table search by one term in a cell with multiple terms.
Hello there, I am using a Lenovo P1 and working in Office 365 Apps for Enterprise Excel version 2110 (Build 14527.20276), I'm building a workbook to track Bill of Materials for industrial automatio...
jontko Perhaps Power Query is something for you. Attached an example based on the data you provided. Type the location C14 (not case sensitive) and press Refresh All on the Data Ribbon. Then the green table should reflect the selected location instantly.