Carl,
a little different that the layout that you asked for, but it does work. It
will look like
09:30:05 || A || E1;Y0;U4;S2;AG;Q0;B5
09:30:05 || B || S7;C2:A5
09:30:15 || B || MA;G7;A6;N4
09:30:15 || A || K0;B7;CK;SC;AK;AJ
Add the UDF below to a standard code module.
Then in the worksheet where you want the formula, select an array of cells
that will be at least as many columns and rows as you want, hit F2, and in
the formula bar, enter your formula, such as
=MultiConcat(C5:C256,";")
which is an array formula, so commit with Ctrl-Shift-Enter.
BTW I found the original UDF, a gem from Bernie Dietrick. I removed the
unique and filtered options as well.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"carl" <[email protected]> wrote in message
news:[email protected]...
> THanks again. Was not sure how to use the link below. I sent you an
example
> directly. Appreciate your help.
>
> "Bob Phillips" wrote:
>
> > You could post an example at http://www.savefile.com/filehost/ and let
me
> > know your URL. But show expected results as well.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "carl" <[email protected]> wrote in message
> > news:[email protected]...
> > > Thanks again Bob. The fomating of this post makes it tough to explain.
> > > Perhaps I could send you an example spreadsheet. If so, just let me
know
> > > where to send it.
> > >
> > > "Bob Phillips" wrote:
> > >
> > > > Carl,
> > > >
> > > > Sorry to keep pushing mate, but that data looks scrambled to me. I
> > cannot
> > > > tell whether Row 1 is a label in a cell, signifies a row or what,
And is
> > the
> > > > 10:30:00 in B, C.? Is AM U4 Q1 all in one cell. If you could relay
> > before
> > > > and after I can give it a shot, but at present I am not clear what
is
> > > > required.
> > > >
> > > > Another thing, is this to work on a set of rows, or just one? If the
> > former,
> > > > can you give an example with more than one row of results?
> > > >
> > > > --
> > > >
> > > > HTH
> > > >
> > > > RP
> > > > (remove nothere from the email address if mailing direct)
> > > >
> > > >
> > > > "carl" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > Hi Bob. Thank you trying to help me.
> > > > >
> > > > > The function concatenates a selected range. I tried to show the
> > expected
> > > > > results in the last table of my post:
> > > > >
> > > > > ColA ColB ColC
> > > > > Row1 Time A B
> > > > > Row2 10:30:00 AM U4 Q1
> > > > > Row3 9:30:00 AM E1;Y0 D1;Q1
> > > > >
> > > > > For example in B2, I need a formula to look at the value in $A2
and
> > $B1,
> > > > > find all values in the data table that map up to these 2 cells,
and
> > > > > concatenate them with a ";" as the separator.
> > > > >
> > > > > Sorry I can't explain this any better.
> > > > >
> > > > > Thank you again.
> > > > >
> > > > >
> > > > >
> > > > > "Bob Phillips" wrote:
> > > > >
> > > > > > I can see that ConcatUF is a UDF of yours, which you don't show,
but
> > I
> > > > don't
> > > > > > get what the formula currently does or what you want.
> > > > > >
> > > > > > Can you try re-posting with the start data (use a character as a
> > cell
> > > > > > delimiter like ||) and expected results?
> > > > > >
> > > > > > --
> > > > > >
> > > > > > HTH
> > > > > >
> > > > > > RP
> > > > > > (remove nothere from the email address if mailing direct)
> > > > > >
> > > > > >
> > > > > > "carl" <[email protected]> wrote in message
> > > > > > news:[email protected]...
> > > > > > > I would like to use this formula
> > > > "=ConcatUF(times!B7:B16,";",FALSE,FALSE)"
> > > > > > > in the table below.
> > > > > > >
> > > > > > > ColA ColB ColC
> > > > > > > Row1 Time A B
> > > > > > > Row2 10:30:00 AM
> > > > > > > Row3 9:30:00 AM
> > > > > > >
> > > > > > >
> > > > > > > My data table is setup like this:
> > > > > > >
> > > > > > > ColA ColB ColC
> > > > > > > Row1 Time A B
> > > > > > > Row2 9:30:00 AM E1 GG
> > > > > > > Row3 9:30:00 AM Y0 D1
> > > > > > > Row4 10:30:00 AM U4 Q1
> > > > > > >
> > > > > > > Can the formula be modified to perform the concatenation like
> > this:
> > > > > > >
> > > > > > > ColA ColB ColC
> > > > > > > Row1 Time A B
> > > > > > > Row2 10:30:00 AM U4 Q1
> > > > > > > Row3 9:30:00 AM E1;Y0 D1;Q1
> > > > > > >
> > > > > > > Thank you in advance.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >
Bookmarks