Pivot Table Counting Text Issue

  • Thread starter Nirmalya Choudhury
  • Start date
N

Nirmalya Choudhury

I have a data table with columns A - I called 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.
 
Top