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

    V3 how to split data into columns between underscore and and dash when there can be more than one

    https://chandoo.org/forum/members/bosco_yip.12515/ back in sept 22 Bosco_yip you gave me an amazing formula and it worked a treat until the year changed to 2023 this was the amazing formulas but it is now producing the information and putting the date as 2023 and the very last one combining...
  2. K

    how to split data into columns between underscore and and dash when there can be more than

    AUSP Policy ID: 320764 Eff: 29/09/2021 ___10 Jan 2022 - Daniel Joiner WA___ Status changed to Complete ___11 Jan 2022 - Jo Atwell___ am trying to split the above date and I want the date and the name in a new column - the data could exist of more than just 2 dates and names it could be 20 or...
  3. K

    how to split data into columns between [ ] when there can be more than

    AUSP Policy ID: 320764 Eff: 29/09/2021 Martin Ayles 63 Pty Ltd [10 Jan 2022] [Daniel Joiner WA] Status changed to Complete [11 Jan 2022] [Jo Atwell] am trying to split the above date and I want the date and the name in a new column - the data could exist of more than just 2 dates and names it...
  4. K

    help - something is not working with my formula

    =SUM(SUMIFS(DATA!$B$2:$B$543,DATA!$BQ$2:$BQ$543,{"9","10"},DATA!$BT$2:$BT$543,"moderately well",DATA!$CA$2:$CA$543,{"NSW","ACT"})) this formula when I just asked for a "9" it gave me the perfect answer but when I wanted to combined the response for both a "9" and a "10" it is only giving me the...
  5. K

    nested if equation concatenate to combine text $ but 3rd condition not work

    Good Evening I have 3 conditions and the formula I am using gives the correct answer for "no reinstatement" and "1 x reinstatement" but when calcuations!C37 has "2 x reinstatement" it supplied the same answer as "1 x reinstatement". calculations!C28 is a drop down box with the 3 conditions...
Back
Top