Prev: how replace comma with point in import data
Next: Can I use AVERAGEIFS?
From: Tracey on 25 Nov 2009 06:42
Hello,

I have a work sheet "Raw Data" of about 1500 rows and 30 Columns. In columns
K, K, L, M, T and W are names of staff. In worksheet "Lookups" I have a
defined list of "Leavers".
I need to return the names of the leaver/s in the last column of the "Raw
Data" sheet.

eg:

Row 15 Column K contains "Joe Blog" Column M contains "Micky Mouse" and
Column W contains "Jane Doe". in my defined list of leavers "Joe Blog" and
"Jane Doe" are listed, in the last column of the "Raw Data" I need it to read
"Joe Blog, Jane Doe"
also, one name could be in multiple columns in the same row.

Your help is greatly appreciated.

KR
Tracey
P.S I'm using Excel 2002


From: Pete_UK on 25 Nov 2009 06:56
Check out your earlier post.

Pete

On Nov 25, 11:42 am, Tracey <Tra...(a)discussions.microsoft.com> wrote:
> Hello,
>
> I have a work sheet "Raw Data" of about 1500 rows and 30 Columns. In columns
> K, K, L, M, T and W are names of staff. In worksheet "Lookups" I have a
> defined list of "Leavers".
> I need to return the names of the leaver/s in the last column of the "Raw
> Data" sheet.
>
> eg:
>
> Row 15  Column K contains "Joe Blog" Column M contains "Micky Mouse" and
> Column W contains "Jane Doe". in my defined list of leavers "Joe Blog" and
> "Jane Doe" are listed, in the last column of the "Raw Data" I need it to read
> "Joe Blog, Jane Doe"
> also, one name could be in multiple columns in the same row.
>
> Your help is greatly appreciated.
>
> KR
> Tracey
> P.S I'm using Excel 2002

 | 
Pages: 1
Prev: how replace comma with point in import data
Next: Can I use AVERAGEIFS?