Forum

Hi Zdenek, Welcome to our forum! Unfortunately you can't force it to place the first axis labels horizontally. If this is important then perhap...

Yes, it's ideal if you have a folder that only contains the files you want to get, that way you don't need to worry about filtering the file names upo...

Hi Mike, Yikes, that sounds messy. Not that I can think of. You'd maybe have to write some VBA to do the sorting of the combo boxes because these a...

Hi Frans, There is a specific way to apply conditional formatting to PivotTables values areas so that it dynamically updates with changes to the Piv...

Hi Frans, Why don't you use 'Files from Folder' to get the data with Power Query. That way you just add your new 2019 file with the new lines to th...

Great use of Dynamic Arrays. Thanks for sharing, Howard. I've put a link from your comment to this forum post so people can find the workbooks.

Hi Mike, Is it possible that this table is a Power Query table? If the data is being loaded to the table by Power Query then it will overwrite anyt...

Hi Rebecca, You can slow down the video using the controllers e.g. Shift+Left Arrow slows it down. There is a list of the keyboard shortcut video c...

Yes, please send the file including example of every scenario. Please also be clear whether C1=text, if text is the word "text", any text, any cell th...

Hi Eithan, I think what you're describing is the SUMPRODUCT function e.g. =SUMPRODUCT(A1:A50,B1:B50*(C1:C50=100)) Mynda

Great. Glad you took the time to give it a go and in the process discovered some other functions 🙂 Most people give up too easily. This tenacity wil...

Hi Anne, The formula above won't add a 0 in front of numbers that contain 10 digits. Perhaps you can share your file so we can troubleshoot. Myn...

Hi Andy, Power Query has a Date.IsInCurrentYear function that you can use to identify dates in the current period and then apply a filter to exclud...

AFAIK refresh is not controlled from within the query. It either refreshes or it doesn't, in order for the query to 'see' if the file is there it need...

Hi Jacek, Power Query doesn't have an option to refresh under the conditions you describe. This is a job for VBA. I'll move this post to the VBA fo...