Forum

Hi Kaspars, That version you have on your Uni PC should work. Please send me the file you're using that you've added the user 2 data to so I can te...

Ok. Good luck! I recommend you use Power Query to reformat your data layout:

Great to hear you've seen the light, Mike 🙂 Onwards and upwards!

Hi Sonny, Oh, ok. That's easy. Change the data type for the column to whole or decimal number. Those values with text will return errors. You can s...

Hi Jerry, Can you please upload the file and image again as it looks like the post was submitted before the files finished uploading. Thanks, ...

Hi David, There's no logical test for the Non_Excludable criteria, so it won't work unless that named range returns an array of Boolean values. ...

Hi Chrisphine, Welcome to our forum! Excel isn't designed to change based on selection of a cell. If you want formulas to update based on a diff...

Hi Toni, Welcome to our forum! We don't have any templates, sorry. It's highly unlikely that you'll find a template that does what you want. Mai...

Hi Mike, Yep, your data is in the wrong format. When you look at the PivotTable on the Pivotmainchart sheet you should have a 'date' field in the R...

Hi Alexandra, Have you seen my HR Dashboard tutorial which covers how to calculate turnover using Power Pivot, which is where you should be calcula...

Hi Sonny, The code below only removes letters from the string so you're left with numbers. Note: It doesn't remove special characters, and it assum...

Hi Kaspars, It works fine for me. Did you get your version of Excel updated to include the dynamic array functions? Mynda

Hi Toni, Thanks for clarifying. See example file attached. Note: the vehicle names aren't the same as yours because it took me long enough to re-ty...

Hi Toni, It looks like you're using Power BI. This data layout isn't supported in Power BI. How are you wanting to use this data once it has been p...

Hi Alexandra, Your example isn't clear, sorry. You have a PivotTable in the file, but I don't know what you're wanting to see specifically. You men...