Question about count ONLY different Texts in a range.

[ldiaz]

I want a formula that can count only text that are different but only one of
similar texts, example: -nsk are 2 but the formula must count 1, -nsb is 1
then the formula must count 1, -nst is 3 the formula must count 1, -nst-5222
is 1 the formula must count 1 a total of 4.


Count = 4
A-X00-1XR-NSK
A-X00-1XR-NSK
A-X00-1XR-NSB
A-X00-1XR-NST
A-X00-1XR-NST
A-X00-1XR-NST
A-X00-1XR-NST-5222

also, if I use filter ommiting -5222 then the result must be 3

please help, and thanks in advanced.

 

[Gary''s Student]

=SUM(1/COUNTIF(A1:A7,A1:A7))

This is an array formula that must be inserted with CNTRL-SHFT-ENTER rather
than just the ENTER key

 

[Pete Rooney]

If you DON'T want an array formula, you could try:

=SUMPRODUCT((Names<>"")/COUNTIF(Names,Names&""))

Where "Names" is the range of cells you want to refer to.

Thus, this could also be be:

=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))

Cheers

Pete

 

[ldiaz]

Hi gary, it works OK, but how it will work if I use filter ommiting
A-X00-1XR-NST-5222 ? , it should count just 3

Thanks?

 

[ldiaz]

Thanks, it works perfectly

 

[ldiaz]

Thanks Pete, it works perfectly..

Ldiaz