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