L
Legacy 143009
Guest
Hey,
I was thinking about this question in a different way;
https://www.mrexcel.com/forum/excel...dentifier.html?highlight=order+mix+identifier
So let's think you have:
A B
1 a
1 b
1 b
2 c
2 d
And let say I want the end result in Column C as:
C
ab
ab
ab
cd
cd
So how about merging unique texts in SUMPRODUCT function? Maybe something like:
=SUMPRODUCT(($A$1:$A$5=A1)*CONCATENATE(SOMEUNIQUEVALUESARRAY($B$1:$B$5)))
First question, what can be the formula for SOMEUNIQUEVALUESARRAY($B$1:$B$5)?
Second question, even it's possible return unique values, its length will be 2. How to multiply it by 3 in SUMPRODUCT?
The third and the last, it it possible to concatenate text?
At least how to try:
SUMPRODUCT(($A$1:$A$5=A1)*CONCATENATE($B$1:$B$5))
and have
abb
abb
abb
cd
cd
Thanks a lot!!
I was thinking about this question in a different way;
https://www.mrexcel.com/forum/excel...dentifier.html?highlight=order+mix+identifier
So let's think you have:
A B
1 a
1 b
1 b
2 c
2 d
And let say I want the end result in Column C as:
C
ab
ab
ab
cd
cd
So how about merging unique texts in SUMPRODUCT function? Maybe something like:
=SUMPRODUCT(($A$1:$A$5=A1)*CONCATENATE(SOMEUNIQUEVALUESARRAY($B$1:$B$5)))
First question, what can be the formula for SOMEUNIQUEVALUESARRAY($B$1:$B$5)?
Second question, even it's possible return unique values, its length will be 2. How to multiply it by 3 in SUMPRODUCT?
The third and the last, it it possible to concatenate text?
At least how to try:
SUMPRODUCT(($A$1:$A$5=A1)*CONCATENATE($B$1:$B$5))
and have
abb
abb
abb
cd
cd
Thanks a lot!!
Last edited by a moderator: