COUNT UNIQUE ENTRIES IN FILTERED DATA

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
F

FARAZ QURESHI

Subtotals work great to present sum or total of any visible cells while using
Autofilter.

However, now I have a data like:

CASE CLASS RATE AMOUNT
ABC 1 10 10,000
DEI 1 10 11,000
GHI 2 9 12,000
JKL 3 10 14,000

I have filtered the data.

How can I have the total UNIQUE CLASSES be counted if I filter data by RATE
= 10, "2" (1 occurring twice & 3 only once)?

Any help highly regarded.

Thanx.
 
Countif helps only in counting total not UNIQUE in only VISIBLE CELLS in
FILTERED data.
 
Hi

You could add an extra column to your table with the formula
=IF(COUNTIF($B2:B2,B2)>1,"",COUNTIF($B$2:B2,B2))
Copy down as far as required.
Include this new column in your filter, selecting (Non Blank), and your
Subtotal value will be correct.
 

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

Back
Top