summarizing data in excell

A

apurwanta

Hi,

I need help please.
I am creating a staff scheduling.

the format is like this
date date date date date date
name client A client A client C client C client D client D
name client B client B client B client E client E client E
name client B client B client C client D client D client D
name client B client B client B client E client E client E
name client A client A client A client E client E client E
name client A client A client C client C
name client D client D
client D

Right now, i am planning to create a summary per client which showing the
staff participated in each client and the date we perform work on the client.

I am thinking to use Vlookup function.
To do so first i make second table which copy the name column between each
column which make the table like this

date name date name date
name client A name client A name client C
name client B name client B name client B
name client B name client B name client C
name client B name client B name client B
name client A name client A name client A
name client A name client A name client C

After i have the table above, then i create next table which will be the
summary per client


date date date date date
client A name name
name name
client B name
name
Client C name name
name name


it should have been easy with vlookup function which looking the client name
in the table 2 and extracting the staff name which is on the column next to
the client name in the table 2.
but the problem is vlookup function will only take the first data it meet.
so if in the same column there are 2 client A, the second client A wont be
taken to table 3.

Could you please help me with the vlookup function?
if it's not possible using vlookup function, what formula should i be using
to summarizing table 1 per client name?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top