COUNT UNIQUE ENTRIES IN FILTERED DATA
 

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.

COUNT UNIQUE ENTRIES IN FILTERED DATA
 

Have you used the countif function

"FARAZ QURESHI" wrote:

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.

COUNT UNIQUE ENTRIES IN FILTERED DATA
 

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

"Debbie" wrote:

Have you used the countif function

"FARAZ QURESHI" wrote:

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.

COUNT UNIQUE ENTRIES 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.
--
Regards
Roger Govier

"FARAZ QURESHI" wrote in message
...
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.