Excel Formulating Help.. Again?

Question

I'm trying to get excel to count the number of DIFFERENT entries i have. And each entry is alpha numeric and random so i can't choose the criteria.

EX:

aa11
aa11
bb22
aa11
bb22
aa11

I have a total of 6 rows but only 2 Different kinds of entries. I'm trying to get it to tell me the answer is 2.

Again, the entries are all random and i CANNOT choose the search criteria. And i have 1000s of different possibilities.

Any suggestions? I don't know VB. If i need to use it, then i'll have to find some one here. Unless you're good like that.

Answer 1

Not pretty but quick. Make sure it is all in the same column. Select Data the Pivot Table. You want first choice on the first pop up. then make sure all your data is selected on the second. Next pop up select new table in the same file. Then grab the column heading you want counted to the Drop Row Fields Here box. However many rows you have that's how many different entries you have.

(If you also drag the field heading the Drop Data Items Here box it will tell you how many of each.)

Answer 2

Try this Excel Add-in I made call UCOUNT.xla which can be download at http://www.freewebs .com/swhtam/ YA/UCOUNT.xla

Usage: =UCOUNT(Range)
Note: blank cell(s) in range is not counted as unique value, range can be any combination of row x column.
Return: No. of unique data count in a block of cell(s).

Hope this helps.

Please note that i put 2 space in the link above to get around the 999 page error, so take the space out to use the link thanks

Answer 3

try a pivot table