Forum

Hi Guido, Welcome to our forum! Unfortunately, you're not able to have major units in line with month start dates as they are always equally spaced...

Hi Bax, The Excel.CurrentWorkbook function designed for this requires the data in Tables or a named range. The workaround, is to get the data from ...

Hi Ramez, Note: this is an Excel forum, so these solutions are for Excel. There is no guarantee they will work in Sheets. The data validation li...

Hi Joanna, Welcome to our forum! I just tested linking a formula from Sheet1 to Sheet2 which contains collapsed grouped columns and I didn't hav...

Hi Ivan, Thanks for sharing the example file. The bottom 3 options do not need a column to count because they are counting rows grouped by the colu...

Hi James, I don't have any tutorials on cohort analysis (it's a pretty advanced topic), however you might find these posts that relate to custom re...

Hi Jodi, Thanks for the file, however I presume this is not the structure of the data in the fact table. Not only is it not in a tabular layout, it...

Glad I could help, Tom

Hi Tom, I suspect this is how the table column name is formatted. Does the column named [Trailing 3-Month Average for Cash Receipts] have line brea...

If you don't have dynamic arrays, then I'd do this with helper columns. My head would explode if I had to write a Ctrl+Shift+Enter array formula for t...

Hi Aayushi, If you have Microsoft 365 you can use this formula: =FILTER(A59:U59,BYCOL(IFERROR(SEARCH(V1,A62:U98),0),LAMBDA(array,SUM(array)))) ...

In Excel we would use a stacked bar chart for this and set the fill colour for the dummy series below Salaries etc. to 'no fill'. Not sure if you coul...

Hi Keith, Power Query can only load to the current workbook. It cannot create a new workbook or load to another workbook. If you want to reuse the ...

Hi Ayal, It's difficult to troubleshoot without the file, but to be clear, if you change the formula to this: =FILTER([SprayAsistFrm.xlsx]SprayA...

I assume so. You'd have to test it to see for sure.