Forum

Hi Aye, I've modified the custom function, added a sorting step to sort the rate and Date descending. This way, the highest date will be always on ...

Hi, Make sure that "Potenzial" column is formatted as Number, not text, this might be the problem.

Hi Aye, There is already a column in the attached file (also attached at your other posts), that checks if for the same ID, all Dates-Facilities-Ca...

Hi, Whenever you click into the formula bar to edit the formula, all the ranges used in formula will be highlighted, there is no way to highlight j...

Hi Aye, Please do not open multiple topics if your data is the same and you just need a different calculation. See the reply here: Once you cl...

Hi Aye, The descriptions from your file are very confusing, hard to see a logical pattern. Please take your time to clarify the logic, I tried to f...

In the query, you can add an index column, based on that index column you can calculate and add a new column: rows 1 to 999.999 will be part of the 1 ...

Hi Stefano, You checked in Advanced options in Excel I guess? Check the regional settings in: Control Panel>Clock and Region>Change Date, ...

Hi Martin, If you want to paste data rom textboxes into the correct sheet cells, the code from your CommandButton1 should look like this: Wi...

Can we see a sample file?

You're welcome, glad to hear you managed to make it work.

Hi Aye, You will have to use the Group By function from Transform tab. Group By has 2 sections: Group By, where you can select 1 or more columns: '...

Hi Rose, Because the page number depends on the data from each page, the problem can be solved only by moving data around. The sorting should be...

Hi Dale, If users cannot handle a simple pivot table, then I doubt that they will be able to handle complex array formulas. As you mentioned, pi...

Hi Filip, Is that a Power Query error or a Power Pivot error? You mentioned that Power Pivot raised the error, but I guess it's just a typo. If ...