Search results

Bosco_Yip to the rescue again - you are a superstar and exactly what I needed thank you so much :)

thankyou so much for your response :) - i have confirmed my excel is the most upto date. that other formula did not work . the formula that Bosco has supplied had worked a treat until we had a mix of 2022 and 2023 dates cheers

thanks Bosco for having a look at this again the previous thread where you designed this formula https://chandoo.org/forum/threads/how-to-split-data-into-columns-between-underscore-and-and-dash-when-there-can-be-more-than.49141/ so your formula broke up the info in the source splitting the...

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

OMG Bosco you are absolutely a genius - you really are an excel ninja - thank you thank you thank you:) it works a treat

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

so sorry about your hearing. I have a question about my original question - I was asking the report to replace some data with the bracket thinking it would work but they are now saying they can if the data was like this do you have an option to get the same info - i tried replacing your "["...

You are welcome and wish you all the best on your healing journey sending.

Bosco_Yip Thankyou so much the a) worked a treat - you are a legend !!!!! I copied it down to the next that had 6 dates and it still worked. I am so sorry to hear about you health. Thankyou for taking the time out to answer this and Sending you lots of healing energy. I went through a...

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

Thanks so much

thanks :)

you are a legend - thanks you so much that worked perfectly just for my info - so does that mean that in a sumifs equation you can only have 2 conditions that can choose between more than one options ? so another words if I wanted to add a condition on another column to add up for 2 choices in...

Hey Narayan what I am trying to do is one column has a count so then another column has the condition of words like extremely well or moderately well and another column has the condition of different states and for the state of NSW I need to include ACT and NSW and another column has number 0...

hey Hui that did not make any difference unfortunately

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

Thanks everyone what a great forum anupam thank you for testing my formula and you understood perfectly -you are right it has something to do with cell c37 where I had to add the 2xreistatement in the drop down box for some reason it does not seem to be reading it I now just have to work out...

I find myself doing a lot of tick off between 2 sheets while trying to reconcile and I often use pivot tables - I often find it easier copying and pasting the columns of data that i need to compare from each sheet into one sheet adding an extra column and putting a name to identify which sheet...

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