Question description:
This user has given permission to use the problem statement for this
blog.
i need to pull employee numbers and names and match them on a new worksheet using pivot table?
Solved by S. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
09/08/2017 - 05:22
Hello Welcome to GotIt Pro.
User
09/08/2017 - 05:22
I dont know if I need to be using a pivot table or lookup for what i need?
Excelchat Expert
09/08/2017 - 05:23
May I have a look at your data?
User
09/08/2017 - 05:27
ok
User
09/08/2017 - 05:27
so i need to turn this data into a pivot table
Excelchat Expert
09/08/2017 - 05:28
yes. now you want to match what with what?
Excelchat Expert
09/08/2017 - 05:28
on basis of?
User
09/08/2017 - 05:28
and i only need employee name, number, premium total, and employer total
User
09/08/2017 - 05:28
i don't know how to
Excelchat Expert
09/08/2017 - 05:28
let me show you how to create a pivot table.
User
09/08/2017 - 05:29
display the employee number on the pivot table
Excelchat Expert
09/08/2017 - 05:29
click on Data -> Pivot Table
User
09/08/2017 - 05:29
without it summing
Excelchat Expert
09/08/2017 - 05:29
okay
User
09/08/2017 - 05:29
in excel
Excelchat Expert
09/08/2017 - 05:30
In excel you have to go to Insert and then click pivot table on left
User
09/08/2017 - 05:30
i already created my pivot table with all my info
Excelchat Expert
09/08/2017 - 05:30
then what can i help you with?
User
09/08/2017 - 05:31
except the employee number, it has to reflect 6 digits
User
09/08/2017 - 05:31
and i need to match it to the corresponding employee on the table
User
09/08/2017 - 05:31
so
User
09/08/2017 - 05:31
if
User
09/08/2017 - 05:31
Boy George in A5..
User
09/08/2017 - 05:32
I want to figure out how to put his employee number in B!
User
09/08/2017 - 05:32
B1*
User
09/08/2017 - 05:32
Boy George in A1 sorry
Excelchat Expert
09/08/2017 - 05:32
yes
Excelchat Expert
09/08/2017 - 05:33
here you go
User
09/08/2017 - 05:33
can you show me how?
User
09/08/2017 - 05:33
will this work if...
User
09/08/2017 - 05:34
I have the name listed multiple times in a row?
Excelchat Expert
09/08/2017 - 05:34
you just have to click on Values from pivot table windw and add emplyee number
Excelchat Expert
09/08/2017 - 05:34
yes it will work at every condition
Excelchat Expert
09/08/2017 - 05:34
even if you add more names and more employee numbers, it will update
Excelchat Expert
09/08/2017 - 05:35
did you get it?
User
09/08/2017 - 05:35
do i add employee number to Values?
Excelchat Expert
09/08/2017 - 05:35
are you there?
Excelchat Expert
09/08/2017 - 05:36
yes exactly
Excelchat Expert
09/08/2017 - 05:36
add it plz.
Excelchat Expert
09/08/2017 - 05:36
first add names then add the emplyee number
User
09/08/2017 - 05:36
it keeps adding the employee number under the name, but i want in to re
Excelchat Expert
09/08/2017 - 05:36
very good
User
09/08/2017 - 05:36
in excel
Excelchat Expert
09/08/2017 - 05:37
you have to uncheck the show total over there.
User
09/08/2017 - 05:37
where?
Excelchat Expert
09/08/2017 - 05:37
like here,, in rows- add field, uncheck show total check box
Excelchat Expert
09/08/2017 - 05:39
can you send screenshot of your excel where you are facing problem
Excelchat Expert
09/08/2017 - 05:39
i have unchecked the box. You can see now its not showing any total
Excelchat Expert
09/08/2017 - 05:40
Kindly come over to this sheet to continue our conversation as session time is about to end: https://docs.google.com/spreadsheets/d/1vOUVAPtfBirnfLPAAuN_uSOigsRDFU5VkGbKKkHxcFk/edit?usp=drive_web
Excelchat Expert
09/08/2017 - 05:40
PLEASE REPLY.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
