Forum

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 ...

Hi, I cover lookup charts here and scroll and sort tables here. Mynda

Hi Julie, Try this in cell N2: =MID(INDEX(B1#,SEQUENCE(COUNTA(INDEX(B1#,,1))-1,,2),9),18,6) Mynda

Hi Deidra, I cover Direct Query in lesson 2.04 of the Power BI course. It's just a way of connecting to a dataset other than via Power Query. D...

Hello! For example, when you create a report you often don't use all the columns in your source dataset. Or you might have data for multiple years ...