=SUBSTITUTE(AConcat(IF(I:I=TEXT(A2585,"000000000"),","&B:B,"")),",","",1)
works fine as array formula, but I would only like to retrieve unique values.
please help
thank you
Daren
=SUBSTITUTE(AConcat(IF(I:I=TEXT(A2585,"000000000"),","&B:B,"")),",","",1)
works fine as array formula, but I would only like to retrieve unique values.
please help
thank you
Daren
Hi,
Why not extract a list of unique values first and then concatenate the reduced list?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks