Counting Unique entries

  • Thread starter Thread starter TONYC
  • Start date Start date
T

TONYC

Is there a quick way of counting unique entries in a spreasheet wit
19,000 records. I want to count suppliers, there are several hundred.
then want to count unique invoices for each supplier. Is there
subtotal formula which allows this within autofilter?

Regards

Ton
 

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

Unique Pivot Table Count 1
Filtered Counting 5
Count unique records that also meet criteria 3
Getting only unique values. 2
Count Formula 1
COUNTING UNIQUE ENTRIES IN FILTERATION 3
Counting unique values 1
COUNT UNIQUE ENTRIES IN FILTERED DATA 3

Back
Top