Forum Discussion

Ben Taylor's avatar
Ben Taylor
Copper Contributor
Jul 06, 2018
Solved

Removing TEXTJOIN duplicates with multiple rows

Hi all,   Attached is a spreadsheet designed to track the start dates of certain modules which happen in different terms, converting a table of this information into a calendar.   The formula det...
Formulas & Functions
TEXTJOIN
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jul 06, 2018

    Ben,

     

    you need simply counting:

    =IF(COUNTIFS($A$5:$A$8,$E5,$C$5:$C$8,G$1),"A","")
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jul 06, 2018

Ben,

 

you need simply counting:

=IF(COUNTIFS($A$5:$A$8,$E5,$C$5:$C$8,G$1),"A","")
  • Ben Taylor's avatar
    Ben Taylor
    Copper Contributor
    Jul 06, 2018

    Hi Detlef,

     

    Thank you very much for your answer - it works very well and is a far simpler solution than my own formulae!

     

    I shall combine this with the IFS function to expand the formula to cover not just "A" dates but extra columns of "B" dates, "C" dates etc.

     

    Thanks again for your swift response, Detlef!

Resources