Last seen: Apr 23, 2025
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 ...
Hi Deidra, Thanks for clarifying. It sounds like you are using the Power BI service to get data from a Workspace that your IT people have published...
Hi Amit, If you have multiple countries in your dataset, then you should have a country column. In which case you can merge the city or state and c...
Hi Deidra, Its' great to hear you're implementing Power BI. I'm a bit confused as to whether you're wanting to use the Power BI data in Excel o...
No, I mean the empty cells have non-printing characters. The numbers look ok. Load the table to Power Query, make sure all empty cells display as '...
Hi Vijay, Looks like there are some non-printing characters in the cells of the FX table that appear blank. If you select a bunch of empty cells, y...
Hi Kasey, Your spreadsheet should have 3 columns: Plant Type (tomato, beans, corn etc.) Task (sow, plant, harvest) Month (enter proper dates...