Forum

Hi Teja, Yes, VBA would be the only way to do this. There are no built-in settings for Excel to detect the size of a screen. The only other opt...

Hi Emmanuelle, Go to PivotTable Options > Layout & Format tab > For empty cells show: N/A Mynda

Hi Joachim, You can use Power Query to do this as explained here: Compare two Excel Lists with Power Query. Mynda

It'll be a floating point problem. Although what you see in the cell might be 200.000000' for example, in the actual underlying XML file it's probably...

From what I remember, the shape map charts in Power BI are fairly limited. You might be able to write a measure that filters the results displayed in ...

Hi Michelle, Great to hear you're making progress through the course. I don't cover dynamic date tables, only auto-generating date tables. Although...

Hi Brandie, Welcome to our forum! The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the g...

I'm not sure I fully understand the question, Robert. That said, my guess is no, it's not possible because the gradient is dictated by the range of va...

No, filters only work with font colour and fill colour. If you do not have access to the account group table from the original database, you can us...

Hi Sarfraz, Excel is not designed to work with formatting as data. I recommend you get a list of the account groups and accounts in the correct ...

Hi Teja, Please upload your Excel file with some example data so we can see the layout and what you're trying to achieve. Note: You need to cli...

Hi Giuseppe, Thanks for clarifying. I think you can use the FILTER function to filter the Rate Card table for the possible rates based on the longe...

Hi Giuseppe, Please see file attached - columns K - O. Hope that's what you're after. Mynda

Hi Giuseppe, Welcome to our forum! Please try uploading your file again. After selecting the file, click the yellow 'start upload button' and then ...

Great to hear