Forum

Hi, Your qs has remained without a response for a few reasons: What you are asking for isn't actually a quadrant map. Quadrant maps have 4 se...

Hi, The syntax is not valid. What are you trying to do with that code? As an example, this line will hide Row 1 Range("A1").EntireRow.Hidden...

Hi Nick, No file attached. You have to click the Start Upload button after selecting the file, then wait for it to upload. Phil

You're welcome Greg, glad to be able to help. regards Phil

Hi Greg, The syntax of Record.Field around the API call wasn't right. The "price" field name was in the wrong place. This works = Record.Fie...

Hi Greg, It's hard to help because I don't have the file and code that you are using. Can you make a copy of the file, change the API credentials ...

Hi Tina, There's no file attached with data to test this on so hard to say. If I use that formula in an empty workbook, that has a sheet called ...

No worries, Phil

Hi Alan, So the end result would look like this? Description Amount SumColumn 1001 150 600 1001 200 600 1001 250 60...

You're welcome. Phil

Hi Serghei, Try this in a new column List.Sum(let _Acc = [Account] in Table.SelectRows(#"Changed Type", each [Description] = _Acc)[Amount]) S...

Hi Paul, No file atatched. regards Phil

This article explains the new Array Shaping Functions Regards Phil

Hi Alan, See attached file. When I was doing this I was getting a problem (bug?) with List.Numbers. The idea is to create a list of x numbers w...

Hi Rahul, You can do this in Power Query with this code which you'll find in the attached file. NOTE the column containing the 'numbers' must be t...