Forum

Sorry, probably some Swenglish from me in my previous question. When I read ”delete and re-install” I assume you are still working in the same Exce...

Have you tried to load the data from a new Excel file?

Hello Reehan, How you write an address differs, so what do your address list look like? Br, Anders

Hello, You can read more about conditional formatting here. The formula needed to check for the two conditions you look for to add light red bac...

Hello Ben, It works fine for me to load the data from this JSON file, see attached. The M code. let Source = Json.Document(Web.Contents("https:/...

Hello Salim, You just need an ordinary VLOOKUP formula for that. You can of course use INDEX and MATCH or XLOOKUP also. =VLOOKUP(E10,D3:F6;3,TRU...

Hello, There are of course different techniques to handle data import to Power Query, which I still regard as the best solution for you. Import Mul...

Hello, What is the issue? What formulas have you tried with? In general, if the year is irrelevant, add a helper column which takes the month an...

Hello Salim, No file was uploaded. Br, Anders

Hello, The best and probably easiest solution is to use Power Query by loading the data from files in a folder. Br, Anders

Hello Zita, What do you mean with the Owner column? Br, Anders

Hello Francis, I have re-arranged your data table and is using a Pivot Table to view and filter the data, see if this approach works for you. Ha...

Hello Frederic, Sorry, the picture didn't upload correctly. Instead of a picture, it is better if you can upload a sample file, no need for real da...

Hello, Simplest solution is to just use Name, Population etc, skipping the need to use Town or City. Br, Anders

Hello Prasad, I am happy to try to help, but that requires you to try on your own to solve the issues and need help to get pass the obstacle that i...