Forum

Hi Barbara, The Sort_By column is created based on your logic and the contents of the Sorter column. So if you want things sorted differently you ...

Hi Barbara, Yes I would say there's probably a way to do what you want but I'm not entirely sure what it is you want. In the image you supplied ...

No worries - glad you found the answer! Phil

Hi Sheralee, No workbook attached. Click on the Start Upload button after selecting the file. Phil

Hi Nesha, Surely it's in your colleague's best interest to learn skills that make their job easier? Why persist doing something the old way just b...

Hi Nesha, Why don't you want to use Power Query? It would make things much easier than using formulae. Regarding the formatting of the numbers,...

Hi Samir, Hard to help with that since it's out of context. Need all the other code around it to see why it isn't working. Phil

Hi, He may have written the code in the editor but I didn't see him run it. If he ran it, it would generate an error because it is incorrect. I a...

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