# Excel - COUNT Function Problem - Expert Solution

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

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.