software

I would like excell to look for at the text value in column A and if that
value exists else wear in the spread sheet in column A, I would like it to
return the value that is in the same row in column B, exculding the value
being test for, in column C. If the value occurs twice I would like to
CONCATENATE both column B values in the same cell for C. I would like this to
occur to a maximum of three values. Please see the sample below: Columns A
and B are entered data and column C is the calculated data.

ABC
1nameclassDesired results
2jimhi
3bobbye
4jimhellohi
5suzyaudios
6suzygoodaudios
7bobbadbye
8jimplayhi hello
9sillycar
10jimhousehi hello playcan you sort your data so the names are together?

--
Regards,
Tom Ogilvyquot;Prohockquot; wrote:

gt; I would like excell to look for at the text value in column A and if that
gt; value exists else wear in the spread sheet in column A, I would like it to
gt; return the value that is in the same row in column B, exculding the value
gt; being test for, in column C. If the value occurs twice I would like to
gt; CONCATENATE both column B values in the same cell for C. I would like this to
gt; occur to a maximum of three values. Please see the sample below: Columns A
gt; and B are entered data and column C is the calculated data.
gt;
gt; ABC
gt; 1nameclassDesired results
gt; 2jimhi
gt; 3bobbye
gt; 4jimhellohi
gt; 5suzyaudios
gt; 6suzygoodaudios
gt; 7bobbadbye
gt; 8jimplayhi hello
gt; 9sillycar
gt; 10jimhousehi hello play
gt;

Unfortunately I can't sort the data because it is a shared file that other
authors will use and it must be in the order in which the data was entered.
The purpose of this function is to collect historical data from a customer in
terms of what they have purchased in the past and put it all in one cell,
exclusive of the purchase the have just made (new record/new row)

quot;Tom Ogilvyquot; wrote:

gt; can you sort your data so the names are together?
gt;
gt; --
gt; Regards,
gt; Tom Ogilvy
gt;
gt;
gt; quot;Prohockquot; wrote:
gt;
gt; gt; I would like excell to look for at the text value in column A and if that
gt; gt; value exists else wear in the spread sheet in column A, I would like it to
gt; gt; return the value that is in the same row in column B, exculding the value
gt; gt; being test for, in column C. If the value occurs twice I would like to
gt; gt; CONCATENATE both column B values in the same cell for C. I would like this to
gt; gt; occur to a maximum of three values. Please see the sample below: Columns A
gt; gt; and B are entered data and column C is the calculated data.
gt; gt;
gt; gt; ABC
gt; gt; 1nameclassDesired results
gt; gt; 2jimhi
gt; gt; 3bobbye
gt; gt; 4jimhellohi
gt; gt; 5suzyaudios
gt; gt; 6suzygoodaudios
gt; gt; 7bobbadbye
gt; gt; 8jimplayhi hello
gt; gt; 9sillycar
gt; gt; 10jimhousehi hello play
gt; gt;