Forum

There is also a defined name used to create the sheet list, make sure you have it in the other book, its name is... SheetList. Normally, if you copied...

Hi, As I suspected, the file name contains illegal chars, a date was used, with forward slash separator. The date should be reformatted: PDF...

Hi Mey, The details are quite confusing, can you prepare an example of the expected results? If you will be able to explain how do you get to those...

Hi Daniel, Made a few changes, but it will not be perfect, simply because the code was designed for US Dollars, with its specific syntax. For a per...

Hi Mey, The problem must be clearly described in the message text, not inside files. This way the problem description can be found by search engines,...

Considering Anders example: "Today is a good day" in cell A1, a dynamic formula can be built, using the AGGREGATE function: =AGGREGATE(15,6,ROW...

I believe you should not use default Date formats to cell format. Use Locale formats, otherwise excel will treat defaults as US formats. (second image...

I think there is another way to have Power Pivot. Try Power BI..., it has Power Pivot and Power Query, and it's an independent application, outside...

Hi Ibrahim, You can find here the complete list of versions where Power Pivot is available: Where-is-Power-Pivot To find what office version you...

Hi Pat, Yes, it is possible, see this post for a solution: query-a-website-url-from-cell-reference#p2415

Hi Jay, Simply change from: =AND($A2>=EOMONTH($A2,0)-7,WEEKDAY($A2)=5) to: =AND($A2>=EOMONTH($A2,0)-6,WEEKDAY($A2)=5) Please use ...

Unfortunately, the pdf's are very dirty, don't think that the OCR engine will be able to recognize the account numbers clearly, in order to know where...

Not possible to hundreds level, only to thousands or millions: #,###,"000" or #,###,,"000000"

Hi Henric, A simple ROUND function will work. Just make sure you use positive values in the num_digits argument for decimal places, and negative...