counting unique strings

  • Thread starter Thread starter Sparky Mark
  • Start date Start date
S

Sparky Mark

I'm having trouble with a formula that will allow me to count the number of
unique strings in a range, however it needs to disregard any blanks in that
range. In the range g4:g1000, there are only a dozen or so values, but I'm
steadily entering the data.

In the MS Knowledgebase (article 268001), it gives this formula.

=SUM(IF(FREQUENCY(IF(LEN(G4:G1000)>0,MATCH(G4:G1000,G4:G1000,0),""),
IF(LEN(G4:G1000)>0,MATCH(G4:G1000,G4:G1000,0),""))>0,1))

However, all that's coming up is "#VALUE!". Why does this not work?
 
Think its an array formula which needs to be array-entered,
viz.: press CTRL+SHIFT+ENTER, instead of just pressing ENTER
 
Max said:
Think its an array formula which needs to be array-entered,
viz.: press CTRL+SHIFT+ENTER, instead of just pressing ENTER
Click to expand...

Excellent, nice one, cheers for that.
 

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

conditions in if statements 1
#value! 5
Formula Help 4
Count by Colour (Text) with other criteria 1
Counting occurences of text 3
VALUE ERROR 5
problem with formulas (2) 7
Unable to name certain ranges 3

Back
Top