How to filter and count unique record?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I want to have the number of cells when I filter on a unique record. Please
let me know how.

Regards
Farnoosh
 
The SUBTOTAL() functions allows us to do math on filtered data. Something like

=SUBTOTAL(2,A1:A100)

SUBTOTAL ignores the "invisible" rows
 
You must log in or register to reply here.

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

how do i show non-unique records (duplicates) using advanced filte 3
Advanced Filter Error - I cannot spot my Error 3
Count Unique Records in Filtered List 2
range of unique cells 6
Non unique records only 2
Append Unique Records to Master Worksheet 5
Autofill Dynamic Range 1
Advanced Filter - Get the unique rows 2

Back
Top