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" wrote in message
...
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" wrote in message
...
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.