Last seen: Mar 8, 2026
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...
Hello Nesha, As long the users that are to work with any of the three separate files have the master file in same path it will work just fine, if n...
Hello Clio, You can find more guidelines to the techniques used here. What is the syntax of your formula? Is it the exact same as in Mynda’s down...
Hello, Without a file to check it is difficult to give any help. Some questions though that might help us to pinpoint where the issue lies. What...
Hello, In SAP you are able to export data to Excel or CSV, have you tried to export? Br, Anders
Hello, As far as I have been able to find out it seems this functionality to use Get data from online services comes with E3 license. I have not us...
Hello, I don't use Google Drive myself so I can't say if it is possible or not, but if not, then you could perhaps sync the folders/files to a loca...