Forum

Hi Maarten, Please watch this conditional formatting formulas tutorial. Hopefully that will answer your questions. If you're still stuck, please sh...

Hi Chen, You use the Web connector to get data from OneDrive. This video is super helpful. Mynda

Hi David, Welcome to our forum! You can use the DATEDIF function to calculate the number of periods and then use SUMIFS to summarsie the data ac...

Hi Laurence, I did fix the conditional formatting as well and I can see it in the file I shared with you. Note: you cannot use month names in the P...

Hi Jen, I'd need to see the file or at least screenshots that document the entire data flow. Mynda

Hi Peter, The equivalent of a VLOOKUP is to merge tables. Once you've merged the tables you can expand the matching column. If there's a match, th...

Hi Laurence, Please see file attached where I've used this formula for the sequence of months start dates: =UNIQUE(EOMONTH(SEQUENCE(1,730,MIN(F1...

INDIRECT is a volatile function, which can put enormous strain on Excel's calc engine resulting in slow workbooks. Volatile functions recalculate almo...

Hi Gary, Welcome to our forum! I wonder if it's limiting the amount of data you can extract at one time. Many sites have limits like this. Mynd...

What version of Excel are you working with, Paul? Hopefully 365. If you have 365 for Group 1: =IFERROR(AVERAGE(FILTER(F257:S257,($F$256:$S$256>...

Hi Laurence, In that case, please share your Excel file or a sample file so we can help you troubleshoot where you're stuck. Please note, we aren't...

In that case, another way to set the condition is to change the 'contains' VAT to 'does not contain' / This will get all rows that aren't a date wi...

Hi Laurence, Welcome to our forum! Please see this post on a similar question which also includes an example file that will hopefully point you in...

Hi Andy, This looks like a new question and unrelated to the previous questions. Please raise a new topic. Thanks, Mynda

Hi Justin, If your source data is another Excel file then that file must be closed for Power Query to access the data. That error usually means ...