Forum

Hi Tim, Taking AC count as an example: =COUNTIFS($C:$C,C4,$D:$D,D4,$E:$E,"AC") In English the formula in cell F4 says, count the number of re...

Hi Joseph, Welcome to our forum! Your LAMBDA version of the formula is not the same. Your INDEX is: =INDEX(A2:A22,SEQUENCE(ROWS(A2:A22)/3,3))...

Hi Sufinah, Welcome to our forum! When you use the data model you cannot add calculated fields and calculated items as these tools are for regul...

Hi Urmas, Please upload an example file that illustrates your desired result. Your explanation is difficult to follow, especially since I don't kno...

Hi Urmas, The correct layout for your data is your 'current table'. From there you can use a PivotTable to group the rows with the same ID into a s...

Hi Kevin, If you remove the Rekeningnr column and rows containing fust, fruit and totaal inc btw, before pivoting then the issue is resolved. Try i...

Hi Anura, Welcome to our forum! Thanks for sharing your file. In this case your column headers are the field names. These don't get converted in...

Hi Steve, Welcome to our forum! Power Query won't be the answer. Please share a sample file containing a subset of your data including a PivotTable...

Hi Lisa, I don't have time for consulting, but I can refer you to a consultant. If you reach out via email website at MyOnlineTrainingHub.com and l...

Hi Lisa, The VacayLookup quasi dimension table is filtering the SampleRoster fact table, therefore the Year field in the PivotTable must come from ...

Hi Morne, Welcome to our forum! I've moved your topic to our 'course members only' Excel Dashboards forum so that I make it a priority to answer. P...

Hi Dave, Welcome to our forum! Please try to upload your Excel file again as it didn't get attached. You need to click 'start upload' after sele...

Hi Bax, You can either use Power Query to combine the 3 tables into one table and load that to Power Pivot, or you can create dimension tables for ...

Hi Johnson, Welcome to our forum. The total is taking the sum of the daily rate x the sum of the working days, rather than the sum of the normal ra...

My guess is the rngTypes named formula is causing the problem, specifically the reference to array CompLog[@] Mynda