Forum

Hi Peter, I've moved this topic to the VBA forum as it's not something you can do with the built in tools available. What you need to do is alter t...

Hi Salim, This is a form control. The settings for how it makes the number change are specified in the form control formatting (right-click the con...

In the Power Query editor Transform tab > Format you can use Trim to do this.

Hi Lea, In the Split Column by Delimiter dialog box under Advanced Options there is an option to split it into Rows. Mynda

Hi Ronie, Welcome to our forum. I'd say whatever you entered in that new row is causing an error which is preventing the updating of the query. Exc...

Hi Saliha, Thanks for providing a clear example. Excel can't easily count based on a cell colour. You're best to put the size data in an adjacen...

I don't do live support, sorry. I used conditional columns. Perhaps it would be helpful for you to learn Power Query. I cover this technique, among ma...

Hi Jitesh, You can see the steps in the Query Editor Applied Steps pane. Mynda

Hi Jithesh, Thank you for clarifying. You can use Conditional Columns to rearrange the data. It's a bit laborious to set up. See attached. Mynda

Hi Alberto, Session 7.05 covers formula firewall errors. Mynda

There's no need to be rude, Jithesh. I did open your file...how do you think I knew that the names were prefixed with First Name, Last Name etc. in my...

Hi Alberto, You can do the cleaning and merging in Power Query and then use the PivotTables to split the data out into separate sheets for each LTP...

Hi Anna, Those numbers (codes) are Excel date serial numbers. This is how the date is stored in Excel. All you need to do is apply a date format to...

Hi Alberto, Thanks for sharing your files, this makes it much easier to understand, although I'm not 100% sure I've got it. It looks like you're...

Hi Marcia, Welcome to our forum! You can create a blank dashboard via the "+ New" drop down in a workspace. e.g. click on 'My Workspace and you'...