concatenateif formula not working ?

  • not sure if its no longer a recognised formula but I have an old spreadsheet where I am using a concatenate if formula

    Code
    =CONCATENATEIF($B$2:$B$82, H2, $E$2:$E$82, " & ")

    but all I keep getting is the #NAME error so I am assuming that this is no longer a compatible formula can any one confirm and if so what can I use to replace this and get the same result many thanks in advance

  • Re: concatenateif formula not working ?


    I've never know of its existence. Which version of Excel are you running?

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Re: concatenateif formula not working ?


    Looks to me like it is a formula that uses this UDF, which was created by Hans a few years ago, see:


    http://www.eileenslounge.com/viewtopic.php?f=27&t=12298


    There is even an extension of the UDF there for ConcatenateIfs which works like SUMIFS or COUNTIFS!


    This is the UDF

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: concatenateif formula not working ?


    You're welcome.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!