Forum

Hello Benn, Your file was uploaded. I am soon leaving home for a short vacation trip, but it means I will be offline till Friday. Let’s see if some...

Hello Bobbe, I doubt this is due to Excel or the slicers in the file. If this happens regardless what programs you run, do check your mouse options...

Hello Benn, Do try to upload your file again, do remove the %20 in the file name first. Br, Anders

Hello Kiran, See attached file for a formula solution, I have renamed and rearranged your data range to make it a little bit easier for me to work ...

Hello, Don't know why think this is an Excel related question. I searched the Internet for "store inventory sample" and got some suggestions. Do th...

Can you share your file?

Hello Benn, Welcome to this forum. It is not a small thing you ask help with, but let’s give it a try. I suggest you build a lookup table first,...

Hello, Thanks Graham for correcting my error. In Swedish the separator is the semicolon, so when I paste in a formula copied from Excel I have to c...

Well, the error seems not to be in the JSON file, but perhaps in your Excel file. If you haven’t already, do try to import the JSON data in a new empt...

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