So I have a list of URLS and I need to return all the related ones into one string. The urls are laid out in a logical manner Domain / directory / sub-directory /
In theory this should work, but I'm getting some random urls in there. I just want any url that contains the group slug none others.
<colgroup><col style="mso-width-source:userset;mso-width-alt:20821;width:488pt" width="651"> <col style="mso-width-source:userset;mso-width-alt:8490;width:199pt" width="265"> <col style="width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:21504;width:504pt" width="672"> </colgroup><tbody>
</tbody>
<colgroup><col style="mso-width-source:userset;mso-width-alt:20821;width:488pt" width="651"> <col style="mso-width-source:userset;mso-width-alt:8490;width:199pt" width="265"> <col style="width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:21504;width:504pt" width="672"> </colgroup><tbody>
</tbody> <style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { border-color: rgb(142, 169, 219) currentcolor rgb(142, 169, 219) rgb(142, 169, 219); border-style: solid none solid solid; border-width: 0.5pt medium 0.5pt 0.5pt; background: rgb(217, 225, 242) none repeat scroll 0% 0%; }.xl66 { border-color: rgb(142, 169, 219) currentcolor rgb(142, 169, 219) rgb(142, 169, 219); border-style: solid none solid solid; border-width: 0.5pt medium 0.5pt 0.5pt; }</style><style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl65 { border-color: rgb(142, 169, 219) currentcolor rgb(142, 169, 219) rgb(142, 169, 219); border-style: solid none solid solid; border-width: 0.5pt medium 0.5pt 0.5pt; background: rgb(226, 239, 218) none repeat scroll 0% 0%; }.xl66 { border-color: rgb(142, 169, 219) currentcolor rgb(142, 169, 219) rgb(142, 169, 219); border-style: solid none solid solid; border-width: 0.5pt medium 0.5pt 0.5pt; background: rgb(217, 225, 242) none repeat scroll 0% 0%; }.xl67 { border-color: rgb(142, 169, 219) currentcolor rgb(142, 169, 219) rgb(142, 169, 219); border-style: solid none solid solid; border-width: 0.5pt medium 0.5pt 0.5pt; }.xl68 { font-weight: 700; text-align: center; }.xl69 { font-weight: 700; }</style>
In theory this should work, but I'm getting some random urls in there. I just want any url that contains the group slug none others.
Code:
=TEXTJOIN(", ",TRUE,IF(B3:B500=D3,A2:A500,""))
URL | Group | URL | |
https://deserthopetreatment.com/ | https://deserthopetreatment.com/ | ||
https://deserthopetreatment.com/addiction-recovery-program-overview/specialized-treatment/ | addiction-recovery-program-overview | https://deserthopetreatment.com/addiction-recovery-program-overview/specialized-treatment/ | |
https://deserthopetreatment.com/lsd/ | lsd | https://deserthopetreatment.com/lsd/ | |
https://deserthopetreatment.com/drug-abuse/pregnancy/ | drug-abuse | https://deserthopetreatment.com/drug-abuse/pregnancy/ | |
https://deserthopetreatment.com/marijuana/ | marijuana | https://deserthopetreatment.com/marijuana/ | |
https://deserthopetreatment.com/drug-abuse/ | drug-abuse | https://deserthopetreatment.com/drug-abuse/ | |
https://deserthopetreatment.com/drug-recovery/inpatient/ | drug-recovery | https://deserthopetreatment.com/drug-recovery/inpatient/ |
<colgroup><col style="mso-width-source:userset;mso-width-alt:20821;width:488pt" width="651"> <col style="mso-width-source:userset;mso-width-alt:8490;width:199pt" width="265"> <col style="width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:21504;width:504pt" width="672"> </colgroup><tbody>
</tbody>
https://deserthopetreatment.com/admissions/what-to-expect/ | admissions | https://deserthopetreatment.com/admissions/what-to-expect/ | |
https://deserthopetreatment.com/ptsd-substance-abuse/ | ptsd-substance-abuse | https://deserthopetreatment.com/ptsd-substance-abuse/ | |
https://deserthopetreatment.com/guides/ | guides | https://deserthopetreatment.com/guides/ | |
https://deserthopetreatment.com/addiction-recovery-program-overview/aftercare/ | addiction-recovery-program-overview | https://deserthopetreatment.com/addiction-recovery-program-overview/aftercare/ | |
https://deserthopetreatment.com/bpd-substance-abuse/ | bpd-substance-abuse | https://deserthopetreatment.com/bpd-substance-abuse/ | |
https://deserthopetreatment.com/ocd-substance-abuse/ | ocd-substance-abuse | https://deserthopetreatment.com/ocd-substance-abuse/ | |
https://deserthopetreatment.com/addiction-recovery-program-overview/therapy-types/ | addiction-recovery-program-overview | https://deserthopetreatment.com/addiction-recovery-program-overview/therapy-types/ | |
https://deserthopetreatment.com/addiction-recovery-program-overview/ | addiction-recovery-program-overview | https://deserthopetreatment.com/addiction-recovery-program-overview/ |
<colgroup><col style="mso-width-source:userset;mso-width-alt:20821;width:488pt" width="651"> <col style="mso-width-source:userset;mso-width-alt:8490;width:199pt" width="265"> <col style="width:65pt" width="87"> <col style="mso-width-source:userset;mso-width-alt:21504;width:504pt" width="672"> </colgroup><tbody>
</tbody>