NBVC

Junior Member

Posts: 5

Quote:

Originally Posted by mmatz

I have a list that has aaa, bbb, cccc, aaa, bbb and want to count the
different instances. So in this example it would be 3 because bbb is
repeated. Is there a formula that does this?

Try:

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

where A1:A10 contain your data to count.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Instances of value in two columns	KN	Excel Worksheet Functions	2	October 24th 07 03:54 AM
Count the number of Instances	louiscourtney	Excel Discussion (Misc queries)	4	July 12th 07 09:16 PM
In a set of dates, can you count the number of Jan '07 instances?	Linda Woodfield	Excel Worksheet Functions	4	June 22nd 07 07:07 PM
Formula to use to count instances of in Excel	Bill	Excel Worksheet Functions	5	December 22nd 05 02:46 PM
Count Instances	Ken	Excel Discussion (Misc queries)	2	April 2nd 05 12:41 AM

All times are GMT +1. The time now is 06:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us