hi,
I need an Udf To concatenate my Range when Multiple Criteria Match,
THANK YOU
hi,
I need an Udf To concatenate my Range when Multiple Criteria Match,
THANK YOU
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
why do you need a UDF?
how about:
Formula:Please Login or Register to view this content.
EDIT
sorry - just noticed you are using Excel 2013 and =CONCAT not available I think
Last edited by kev_; 06-03-2017 at 06:54 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
so for Excel 2013 and earlier
Formula:Please Login or Register to view this content.
or
Formula:Please Login or Register to view this content.
Last edited by kev_; 06-03-2017 at 06:59 AM.
Thank you Kev
is =CONCAT available in 2016
yes =CONCAT is available in 2016
Here is a UDF to replace =CONCAT if you are using Excel 2013 or earlier
the UDF can take a delimiter (optional) if you want to separate with a character:
so if A1=A,B1 =B,C1=C,D1=D
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
and this gives you a formula to concatenate range with multiple conditions:
Formula:Please Login or Register to view this content.
the UDF:
Please Login or Register to view this content.
Last edited by kev_; 06-03-2017 at 07:42 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks