Forum

Hi Rasit, Welcome to our forum! I think Named Sets can help you. Mynda

Hi Jacqui, This formula will give you a list of Thursday and Friday dates where A1 contains the first date you want to start at: =WORKDAY.INTL(A...

Hi Jacqui, It depends on whether those workdays are sequential or not. e.g. are they Monday and Tuesday or Monday and Thursday? Also, please confir...

So the problem is that you can't get a PivotTable to display in the layout shown in the Template sheet. If that's the case then you'd need to write so...

Hi Alison, Unfortunately, the file doesn't really help me understand why the 'Show report filter pages' tool doesn't work for you (I honestly think...

Hi Peter, Have you see this tutorial on scraping data from multiple web pages? I can see from the URL structure that you have parameters in the str...

Hi Shawn, It's difficult to hold a picture of your workbook in my head in order to answer your question. Please upload an example Excel file with s...

Hi Alison, The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the f...

Hi Kabil, The data/business isn't something I'm familiar with. It uses acronyms I don't recognise, so it's difficult to help without further explan...

Hi Jim, That's not incremental refresh in the true sense. The purpose of incremental refresh is to prevent Power Query getting all the data every t...

"In both these cases there should be no problem to autorefresh all the copies of Pivot Table / Power Pivot with a single click on the "Refresh All" bu...

Hi Libor, The answer partly depends on which version of Excel you have and partly on whether you need Power Pivot and DAX function capabilities. ...

Hi Kabil, Welcome to our forum. The purpose of the forum isn't to do this work for you. You would need to make an attempt at it and then if you get...

Hi Katrina, Excel currently can't work with multiple values in a cell and compare them to cells with individual values. Therefore, I would load the...

Hi Kasey, Posting in multiple forums is against all forum rules, including ours. You must declare cross posting so we know not to waste time on que...