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?
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?