Forum

Hi Robert, Try =FILTER(Combo,(Combo[Period Number]=1)*(Combo[Location Number]=105)) Mynda

Hi Reehan, You can't simply download the FILTER function and have it work in Excel 2019. The only way to get the FILTER function is to buy Office 3...

Hi Joseph, Welcome to our forum! This post explains how to add a calculated field to a PivotTable. If that doesn't answer your question, or you...

I agree, Derek, Microsoft's licencing is frustrating and we MVPs have been telling them for years, but their marketing department have other ideas. Th...

Hi Nesha, Why don't you create 3 separate files that get the data from the master file? This would give each user their own view of the data and th...

Hi Derek, Business Premium doesn't have the SharePoint List or Folder connectors. You need Enterprise licencing for that feature. You can see the c...

Hi Shuo, Welcome to our forum! There's rounding not visible on the face of the table visual. Remember Next Year Budget is calculated: Actual * 1...

Hi Maria, The best solution will depend if you want the dynamic reporting date based on data already in the dataset, or a date you enter. If you wa...

Hi Gokhan, You can use Power Query to fix the layout of the data into a tabular format enabling you to count the number of welders per day. See She...

Hi João, I wasn't saying that all queries are refreshed when you refresh a single query, what I meant was when you refresh queries, whether that's ...

Hi Bogdan, Welcome to our forum! How are you calculating the 'on time delivery percentage'? Please provide an example formula that you'd use in ...

Glad you figured it out. All that trial and error leads to far better learning, so while it may have been frustrating at times, it's worth it 🙂 T...

Hi João, Welcome to our forum! Are all users on the exact same build of Excel for Microsoft 365? Do all users have the same spec laptops? ...

Hi Gokhan, In Phil's example file he has split welder 1 and 2 onto separate rows, not separate columns as you have done. You need to format your da...

Hi Bill, In Excel 2010 Power Query is a free add-in that you can download here: When installed you'll have a dedicated Power Query tab on the rib...