Forum

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

I don't do coaching as such, but you can ask me questions when you get stuck. It's a toss-up for you between getting a consultant in to build what you...

Hi Ayanna, VLOOKUP only looks up the first column in the 'lookup_array'. It works for Salary because you have Salary in both the Sub-category and t...

Hi Deidra, This was announced yesterday, which might be useful for you: Announcing new ways to create connected tables in Excel connected to Power ...

Hi Ayal, It's not clear what the end result is that you want, but I suggest you merge the columns first, then split. Mynda

Great! I cover these functions in the Excel Expert course or the Advanced Formulas course, which is an extract of the Excel Expert course. I don't ...