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 the date and name
=IFERROR(FILTERXML("<a><b>"&SUBSTITUTE(SUBSTITUTE($A1,"2022 - ","___"),"___","</b><b>")&"</b></a>","//b["&(COLUMN(A$1)+INT((COLUMN(A$1)-1)/2)+1)&"]"),"")
this is what the formula is providing now that we have changed to the year 2023 yet the 1st date should read 22/11/22 and the 6th date should be 13 jan 2023 but the name should then split into a 6th name
if there is not a date of 2023 the 6th date and name splits but the dates all say 2023 when they should say 2022 if they are the year of 2022
I am hoping Bosco you will know what I need to do to fix - I have tried playing with the formula but I cant get it to correct.
I am sure it is a simple fix but my brain just get my head around it
thanks heaps
cheers Karyn
this was the amazing formulas but it is now producing the information and putting the date as 2023 and the very last one combining the date and name
=IFERROR(FILTERXML("<a><b>"&SUBSTITUTE(SUBSTITUTE($A1,"2022 - ","___"),"___","</b><b>")&"</b></a>","//b["&(COLUMN(A$1)+INT((COLUMN(A$1)-1)/2)+1)&"]"),"")
this is what the formula is providing now that we have changed to the year 2023 yet the 1st date should read 22/11/22 and the 6th date should be 13 jan 2023 but the name should then split into a 6th name
if there is not a date of 2023 the 6th date and name splits but the dates all say 2023 when they should say 2022 if they are the year of 2022
I am hoping Bosco you will know what I need to do to fix - I have tried playing with the formula but I cant get it to correct.
I am sure it is a simple fix but my brain just get my head around it
thanks heaps
cheers Karyn
1st date | 1st name | 2nd date | 2nd name | 3rd date | 3rd name | 4th date | 4th name | 5th date | 5th name | 6th date |
22/11/2023 | Elise Pretto | 22/11/2023 | Julie Clancy | 1/12/2023 | Julie Clancy | 8/12/2023 | Julie Clancy | 23/12/2023 | Julie Clancy | 13 Jan 2023 - Julie Clancy |
AUSP Policy ID: 360279 Eff: 18/08/2022 Manya Wittingslow ___22 Nov 2022 - Elise Pretto___ Followed up broker - Dean Bowen is dealing with this now. ___22 Nov 2022 - Julie Clancy___ Spoke to Dean he has requested accounts details from CBN. ___01 Dec 2022 - Julie Clancy___ Corrections are being processed by the broker and the remaining amount will be taken back soon - unallocated listed undert the name of Boneo Maze. ___08 Dec 2022 - Julie Clancy___ Still on unallocated. ___23 Dec 2022 - Julie Clancy___ Checked again the broker hasn't finalised this yet - sent a follow up. ___13 Jan 2023 - Julie Clancy___ |