Forum

Hello Ken, Check out this blog article on how to import files from a folder with Power Query, I think that is the approach you are looking for. ...

Hello, You need to right click and export to Excel. In SAP the administrators can define that certain data is not allowed to be copied, most likely...

Hello, As Andrew mentions, providing a sample file makes it easier for everyone. Based on your topic label, this blog post gives a good description...

Hello Carlos, There is no file attached. Try to upload it again. Br, Anders

Hello, As mentioned in an earlier post. ”Be sure to select a cell in the column labels area before right clicking > Field Settings (not 'Value F...

Hello, So you intend not to have column F as shown in your sample file Sheet2? Do you intend to have Sheet2 at all? In order to keep the formula...

Hello, You have an old version that does not have these dynamic arrays. Your version is 1902 build 11328.20438. Ask your IT department for an updat...

Hello, Almost same question as in this post. See attached file. I have used same formula as provided by Mynda in linked post, just added a secon...

Hello, Based on your sample data in Sheet2 you can use this formula to create a running total based on column C (the data needs to be sorted in cor...

Hello, What Excel version do you have? The dynamic arrays Mynda is using works currently from Excel 365 version 1907 build 11901.20176. More abo...

Hello, You don’t specify what function you use, but as you use wildcards I assume you use the SEARCH function. A good article to read about sear...

Hello, Try with changing MATCH(2 to MATCH(1. =VLOOKUP(D2,INDIRECT("'"&INDEX(Sheet_List,MATCH(1,--(COUNTIF(INDIRECT("'"&Sheet_List&"'...

Hi Nancy, No pictures attached, perhaps you missed to click the Star Upload button. It is better though if you can upload a file with sample data, ...

Hello Keith, Have you considered using holiday API's with Power Query to get a list of holiday dates? One example of how to get data using API's is...

Hello, It looks to me that you have asterisks (*) instead of quotation marks (”) in the end of your formula. Try copy this formula: =AND(WEEKDA...