what formula to use?

M

mjmack95

what formula do i used to sum a list of text only if they are different.
Example: Tell me how many stores are in this list = Target, Kroger, Target,
Meijer, Target and Sam's Club
Answer = 4
 
B

Bernard Liengme

How many unique items (count)
=SUMPRODUCT(1/COUNTIF(A2:A40,A2:A40&""))
blanks count as an item

=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))
blanks are not included in count

best wishes
 
G

Gary''s Student

With a list in column H:

=SUMPRODUCT((H1:H1500<>"")/COUNTIF(H1:H1500,H1:H1500&""))
 

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

Mapping integers to strings 6
What regular savings, increasing every year to reach goal 11
Excel - Wich Function should I use? 1
How to make repeating drop-down lists? 2
Hide/Unhide with cell double click 3
Drop down list control value in vba 2
Excel does not accept text format! 0
Crazy Variance Formula 0

Top