• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Debaser

    Can i create a sumifs type formula that will pull in text

    It's difficult to make it completely flexible, but as long as the header rows are always in row 7 on the green tabs and the codes are always in column A, you could use something like this: =INDEX(SafeDelivery!$A:$R,MATCH($B8,SafeDelivery!$A:$A,0),MATCH(C$7,SafeDelivery!$7:$7,0))
  2. Debaser

    Can i create a sumifs type formula that will pull in text

    It sounds like you want INDEX and MATCH but you haven't really given much to go on... ;)
  3. Debaser

    Images in another Folder

    Replace Application.ThisWorkbook.Path with the path you want - e.g. "C:\some folder\pictures"
  4. Debaser

    How to Keep/Retain leading Zero’s when I Save as a .CSV file

    Usually the issue is that you are checking the file by opening it in Excel, at which point Excel will indeed remove the leading zeroes. That does not mean that they are not present in the CSV file! Test that by opening it in Notepad or another text editor, not in Excel. When Excel saves a file...
  5. Debaser

    Compile error as variable has not been created yet.

    It may be written but it will not work. Same question I always ask you: did you actually test it? It can't possibly run.
  6. Debaser

    Pivot Table Field and Slicers disappearing

    The issue is that your two slicers are using date groupings on the ETA field. If you don't input a date, the field is no longer a date field and can't be grouped, so they disappear. You already have a month column in the table and you can add a year column , then use those two for the slicers...
  7. Debaser

    Compile error as variable has not been created yet.

    Unfortunately everything Monty wrote was wrong. (that's the problem with blindly using AI to generate your answers) You do not need to declare your variables as Object. Worksheet is just fine. Also you cannot refer to a sheet in a different workbook using its codename unless you set a...
  8. Debaser

    Using Office 2010 VBA In Office 365 Will Not Work

    FYI, cross-posted: https://www.mrexcel.com/board/threads/vba-in-office-365-and-windows-11.1255481
  9. Debaser

    Power Query table transform

    I've done the transformation in PQ in your excel workbook. I assume you can replicate it in the PQ editor in Power BI if that's where you need it. It's just an unpivot and then pivot on the Type column.
  10. Debaser

    Adding a step in M language

    If you filter it, you will see the M code that you want created for you.
  11. Debaser

    SCAN Function Formula

    Try: =SCAN(D6,E10#,LAMBDA(s,c,SUM(s,c)))
  12. Debaser

    Look for words such pattern GOODWIFE GUDEWIFE

    Cross-post: https://www.excelforum.com/excel-programming-vba-macros/1420334-looking-for-pattern-such-goodwife-gudewife.html
  13. Debaser

    SCAN Function Formula

    It appears you do not have an up to date enough version for that formula. It appears to use the ETA SUM function which I think is still only in Insiders Beta.
  14. Debaser

    Understanding countx and sumx

    Those are the formulas in the original post. :rolleyes:
  15. Debaser

    Adding XL version

    I can't see it.
  16. Debaser

    Understanding countx and sumx

    It's basically doing SUM(3) in this instance.
  17. Debaser

    Understanding countx and sumx

    Your CALCULATE statement calculates one value, so CountX on that returns 1 as it is counting the number of values. The actual value calculated is 3 and the sum of 3 is 3, so that's what sumx returns.
  18. Debaser

    Adding XL version

    I think Chandoo was at the Global Excel Summit in London this week. Can't say about the others.
  19. Debaser

    How to run rest API in VBA taking parameter from 1 sheet and store response values in another sheet in columns?

    Now cross-posted here: https://forum.ozgrid.com/forum/index.php?thread/1233661-how-to-run-rest-api-in-vba-taking-parameter-from-1-sheet-and-store-response-valu/
  20. Debaser

    Separate Text and Codes in one row

    Do any of your text descriptions contain a comma? It seems your delimiters are not consistent and fixing that I suspect will be more complicated if it is not ok to just replace commas with pipe symbols.
  21. Debaser

    Personal Macros Disappear from Alt F8 after saving a new macro

    In your personal.xlsb project in the vb editor, try adding a reference (using Tools - References). It doesn't matter which one you choose. Then Debug - Compile VBA project. Now remove the reference, and compile again and see if the macros appear in the Macros dialog?
  22. Debaser

    Adding XL version

    It is definitely possible to add custom user profile fields in XenForo. I can't speak to how difficult it is though.
  23. Debaser

    Syntax error in a simple ISBLANK DAX measure

    It's hard to be sure, but that doesn't look like a calculation that should be a measure; it looks like it should be a calculated column.
  24. Debaser

    Syntax error in a simple ISBLANK DAX measure

    You have 3 opening brackets but only 2 closing ones, and I can't see why you have ALL in there at all (pun intended)
  25. Debaser

    Code for Disable Right click on Excel Slicer in Protected Sheet

    Cross-posted: https://www.myonlinetraininghub.com/excel-forum/vba-macros/code-for-disable-right-click-on-excel-slicer-in-protected-sheet
Back
Top