Forum

Hi Robert, I think you should organize better the data table structure, it will allow you to view reports much easily. See image attached, if it's ...

Salut Bogdan, If you need to put a value in column C, that's not really a conditional formatting, it's a simple formula. Try this formula in C1:...

Hi, PQ does not have such a function, as you already noticed. However, the problem is not new, there are several attempts to solve it, here is o...

Hi Chad, Instead of excel, use Power BI (which contains Power Query and Power Pivot tools) If you install R language in Power BI, you can use a ver...

What you are doing wrong is that you did not used the code provided that was functional. Instead, you are using a different method, but instead of ...

You don't have to recreate the steps. Just start a new project, connect to your Address.xlsx file with data, then go to Advanced Editor, just paste th...

To write into word, save to folder: Range("A1:C20").Copy Scrittura.Selection.Paste Documento.SaveAs ThisWorkbook.Path & "Allegati" & Range("I1...

Yes, it's not available in standalone versions of office. Go to Power BI desktop, the free version has all functions.

here it is

Make sure first that your version of PQ has the fuzzy match function.

You might be able to do something by using fuzzy matching, but it's not very reliable. In attached example, I had to reduce the similarity threshol...

With so unpredictable address variations, it's hard to count them properly with a decent precision unfortunately.

Use a lookup table then, with 2 columns: "City" Column 1 should have the city name, "Lookup" Column 2 should have a space separated text string with t...

Ok, what needs to be done with the tables you mentioned? Will have the same Trusted Data process with same counts? Or there is a different process ...

Hi Steven, Add to data model, Data Model belongs to Power Pivot.