Count data

[JGutierrez]

Hi.
I need count how many things there is in a datarange.
By example: The datarange is...
House House Office Pen Office House
Office Office Pen

The answers is:
3 diferent things (House, Office, Pen)

 

[PaddyD]

duplicate:
http://www.mrexcel.com/board/viewtopic.php?topic=23460&forum=2&3

 

[kskinne]

J,

just an FYI for you - i can see that you need an answer to your question, and i can appreciate that (i've been there myself many times), but rather than creating a new post for the same question over and over again, the best thing to do is to simply reply to you own original post - this will bump the post back to the top of the list, and it will be a lot less confusing for everyone on the board. sorry i don't have an answer for you, but if you hang in there, i'm sure someone will

kevin

 

[JGutierrez]

I'm sorry. You are right. But it's because my Internet connectión was broken sometimes and I thought that my message was wrong.

 

[kskinne]

say no more - not a big deal

good luck finding a solution to your problem