Pivot Table Counting Text Data

  • Thread starter Nirmalya Choudhury
  • Start date
N

Nirmalya Choudhury

I have a data table with columns A - I - Table1.

Column I has a vlookup statement that inputs some text or remains "" if there is no match.

When I use Table1 to create a pivot table, I want the count of text content in Column I. However, the pivot table currently is counting all rows.

Is there any way to fix this issue?

Thanks in advance,
Nirmalya.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Counting Text Issue 0
Pivot Table Data Aggregation 0
Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
Excel does not accept text format! 0
Columns appearing from nowhere, formatting going weird 0
Pivot Table cell values 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0

Top