I have data in col a and col b
I want concatenate all data in col a by criteria in col b, criteria in col b = "union"
Example b2,b5,b10 = union
Then result in d3 = (a2,b5,b10).value
I have formula array vba
D3 = application. Transpose(join([b:b="union",a:a,""],",")
How i cant do use formula array like it use join
AFAIAA you cannot do this with a native formula, array or otherwise.
If you Google ConcatIf, you will find a number of variations on a theme using a User Defined Function (UDF) in VBA. I suspect that is as close as you're going to get.
It does mean that the workbook will still need to be macro enabled.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Yes i know but i has see by jindon post
Its can do
You need to provide a link to the post to which you refer.
If you know you can do it, what's the question?
http://www.excelforum.com/excel-prog...-new-post.html
In this post only range in this cell not offset cell by criteria
Please Login or Register to view this content.
thankyou jindon how if add criteria
Please Login or Register to view this content.
Please Login or Register to view this content.
Sorri jindon i dont see its has solved thankyou
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks