Forum

Hi Larry, I tested adding a dimension table for the error names with a SortBy column that forced the sort order, but that didn't work. It looks lik...

Hi Aye, That's because these columns are not part of the Table, so they don't automatically copy down. I would move these columns to Power Query. Y...

Hi Karen, You're not doing anything wrong, a Merge is like doing a VLOOKUP, so if you have 3 records in one table then it will return 3 records. I ...

Hi Karen, There is a Facebook connector for Power Query. This post explains it from the Power BI tool perspective, but it's the same for Excel. How...

Hi Stefano, Sorry, I'm not aware of how you'd do this. Maybe there is a paid service you can use to convert long and lat to addresses. Mynda

Hi ST, Welcome to our forum. You can use an INDEX and MATCH array formula or SUMIFS. See columns E and F of sheet YKK 2019 award in the file attache...

Great to know it was helpful, Gary!

Congratulations on your hard work and success, Larry! It's great to know we could play a small part.

Hi Junko, That's odd. How did you create the Month column? Is it a formula? A Mynda

Hi Oot, Welcome to our forum! It's difficult to visualise what you want without a sample Excel file, but I'd say you're best to use a PivotTable...

Hi Roxanne, Welcome to our forum! Your formula is fine, however you should aim to have a consistent formula in column F i.e. instead of having a...

Hi Lea, I think your question is incomplete or the workbook is missing? Mynda

Hi Aye, Please see attached. Mynda

Hi Larry, I would unpivot the error table, for me the other layout is a mistake that will lead to pain and frustration in the future. You can use P...

Hi Karen, You can discard the last 3 columns as these are calculated from the data in the Value column. See example attached. Mynda