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

    Construction Budget distribution using GAMMADIST Function

    x posted https://www.mrexcel.com/board/threads/construction-budget-distribution-using-gammadist-function.1255570/ and https://www.excelforum.com/excel-general/1421020-construction-budget-distribution-using-gammadist-function.html
  2. F

    CountIf not working for Spilled data

    Glad to help & thanks for the feedback
  3. F

    CountIf not working for Spilled data

    The formula doesn't work as the filter function returns an array & countifs needs a range. However you can use countifs like =COUNTIFS(INDEX('Raw data'!$E$3:$P$72,,XMATCH('Working sheet'!G4,'Raw data'!$E$2:$P$2,0)),">0",'Raw data'!$B$3:$B$72,"Inactive")
  4. F

    Two font sizes in one cell.

    Glad to help & thanks for the feedback.
  5. F

    Two font sizes in one cell.

    If the cell contains a formula, then you cannot have multiple formats in that cell. You can either have the formula, or the format, but not both.
  6. F

    Help with formula to be divisible by a whole number

    Cross posted https://www.mrexcel.com/board/threads/nearest-whole-number-to-divide-by-to-be-near-a-value.1239423/
  7. F

    Filter Function

    Glad to help & thanks for the feedback
  8. F

    Filter Function

    You could try =FILTER(CHOOSECOLS(Transactions,1,2,match(a1,Transactions[#Headers],0)),((ISNUMBER(SEARCH(" Ending Balance",Transactions[Transaction]))))*(Transactions[Carter Scholarship - Sloan]<>0))
  9. F

    SEQUENCE in a LET formula not behaving as expected

    Glad to help & thanks for the feedback. I already have, which is why I knew about it.
  10. F

    SEQUENCE in a LET formula not behaving as expected

    Excel sees both b & c as an array, which sequence doesn't like. One option is to use =LET(a,VALUE(TEXTSPLIT(A1,,"-")),b,INDEX(a,1,1),c,INDEX(a,2,1),d,c-b,SEQUENCE(d))
  11. F

    VSTACK ignore specific columns in array

    Glad to help & thanks for the feedback.
  12. F

    VSTACK ignore specific columns in array

    How about using Hstack rather than Vstack.
  13. F

    change macro for excel2007

    Also posted on MrExcel & ExcelForum
  14. F

    use "SET" statement with "iif "

    The IIF function evaluates everything, so if Rng is nothing you will get an error with the Union as there is nothing to join.
  15. F

    I need to calculate an answer for multiple cells in one cell

    Cross posted https://www.mrexcel.com/board/threads/help-with-formula.1198426/ and https://www.excelforum.com/excel-formulas-and-functions/1373123-i-know-this-will-be-easy-for-most.html
  16. F

    Excel TEXTJOIN function not working

    Textjoin is limited to 32,767 characters, which is the same as the number of characters permitted in a cell. You formula is trying to return 35,487
  17. F

    seelct item from listbox in web page

    Cross posted on at least two other sites, as normal.
  18. F

    How to create permutations & combinations

    That shows you are using 2019. ;) Try bosco_yip's formula
  19. F

    How to create permutations & combinations

    If you are getting the _xlfn prefix, then you are not using xl365. What version are you using?
  20. F

    How to create permutations & combinations

    What version of Excel are you using?
  21. F

    How to create permutations & combinations

    If you have 365 or 2021 how about =LET(rng,A2:A6,r,ROWS(rng),s,SEQUENCE(r*r,,0),CHOOSE({1,2},INDEX(rng,INT(s/r)+1),INDEX(rng,MOD(s,r)+1)))
  22. F

    Include an OR statement in a count if

    How about =SUM(COUNTIFS(Table1[Fruit],E2:E3))
  23. F

    Combining IF and COUNTIF formula

    Cross posted multiple sites & also marked as solved on one of them.
  24. F

    ListObject...Basics Dr Watson

    You're welcome & thanks for the feedback.
Back
Top