Question description:
This user has given permission to use the problem statement for this
blog.
I need to display the total occurence count of different text variables in a table
Solved by G. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
30/07/2018 - 02:43
Hello
Excelchat Expert
30/07/2018 - 02:43
How are you today?
User
30/07/2018 - 02:43
I am trying to use a pivot table
Excelchat Expert
30/07/2018 - 02:43
Ok.
User
30/07/2018 - 02:43
to display the frequency of text occurence
Excelchat Expert
30/07/2018 - 02:43
Ok
User
30/07/2018 - 02:44
can you see the table?
Excelchat Expert
30/07/2018 - 02:44
Yes
User
30/07/2018 - 02:45
the list on the left (parameter list) is the range of variables
User
30/07/2018 - 02:45
the right columns (A-F) i need to measure
User
30/07/2018 - 02:45
is this something you can help with?
Excelchat Expert
30/07/2018 - 02:46
Give me a minute
User
30/07/2018 - 02:46
ok
Excelchat Expert
30/07/2018 - 02:47
so what exactly the result should show
Excelchat Expert
30/07/2018 - 02:47
for example
Excelchat Expert
30/07/2018 - 02:47
Please go to sheet 2
User
30/07/2018 - 02:47
i need a number of occurence against the air gap text
Excelchat Expert
30/07/2018 - 02:48
so it would show 2
Excelchat Expert
30/07/2018 - 02:48
raster angle and air gap
User
30/07/2018 - 02:49
so I need to count the total number of air gap in columns A to F
Excelchat Expert
30/07/2018 - 02:49
Ok.
Excelchat Expert
30/07/2018 - 02:50
and you want to do this using pivot table only?
User
30/07/2018 - 02:50
i think this is best?
Excelchat Expert
30/07/2018 - 02:50
because the data is not arranged correctly for a pivot table to do count the unique values.
Excelchat Expert
30/07/2018 - 02:51
All the data should be in 1 column then only pivot table will be able to count the unique values.
User
30/07/2018 - 02:51
okay thanks
Excelchat Expert
30/07/2018 - 02:52
There are other way also
Excelchat Expert
30/07/2018 - 02:52
Should I do it with formulas?
Excelchat Expert
30/07/2018 - 02:53
Are you still there?
User
30/07/2018 - 02:54
yes
Excelchat Expert
30/07/2018 - 02:54
How do you want me to do it? With the pivot table or with the formulas?
User
30/07/2018 - 02:54
please
User
30/07/2018 - 02:54
pivot table if possible
Excelchat Expert
30/07/2018 - 02:55
Ok, I will rearrange the data and then will do this with the pivot table.
Excelchat Expert
30/07/2018 - 02:55
Give me few minutes.
Excelchat Expert
30/07/2018 - 02:59
If prompted, please extend the session.
Excelchat Expert
30/07/2018 - 03:01
Here it is
[Uploaded an Excel file]
Excelchat Expert
30/07/2018 - 03:01
Please extend the session so that I can explain the procedure on how to do it.
Excelchat Expert
30/07/2018 - 03:02
We are almost out of time, please extend session
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.
