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