Last seen: Aug 27, 2025
Hi, Have you read and tried the code from these posts You haven't said how you want the results to look so I've produced a table with the st...
Hi, Please attach your workbook so we can see what you are doing. Regards Phil
Hi Pepito, No need for loops, you can do this by splitting the column then searching the resultant list for the colors. Remove any matches, then r...
Hi, You can create a table with this line where the data for the table resides in A1:F6 ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$F$6...
H Tania, You have to explicitly state a test for the IF. As it is you just have IF(D10, ... but it needs to be something like IF(D10<>"",.....
Hi Akeri, There re no shortcuts, if you need to know something then you need to learn it. Please look at our list of courses You can start ...
Hi Doug, Can you please supply your workbooks so we don't have to recreate everything. The IF in your 2nd image doesn't have any logical test? ...
Thanks Dennis. I've modified the function to reset in October - see attached. Regards Phil
Hi Shardul, Excel will display dates in whatever your regional settings define. So if your regional settings use m/d/y then that is what you are g...
Hi Guy, There's no image attached. Have you read these blog posts : Getting Started with API's in Power Query Connecting to an OAuth API ...
Hi Dennis, Please see attached file. This works out the monthly change based on the Account Number and the Customer. I'm not sure that Row 20 i...
no worries.