Watercolor artist

Posts: n/a

Thanks Dave. It does exactly what I need.

Howard

"Dave Peterson" wrote:

one way:

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

(adjust the range to match, but don't use the whole column)

Watercolor artist wrote:

I need a formula that will count all the different instances of a value in a
column. For example, in the example below, the count would be 3 because, "1,"
though it occurs thrice, will only be counted once.

Col A
1
1
2
3
1

Thanks in advance,
Howard

--

Dave Peterson

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
SUMPRODUCT Formula to Count Row of data Below Matched Criteria	Sam via OfficeKB.com	Excel Worksheet Functions	8	February 3rd 05 01:37 AM
Counting "rows", i.e. simultaneous criteria for multiple cells	gkline	Excel Worksheet Functions	2	November 19th 04 07:30 AM
Group by count formula	nobrabbit	Excel Worksheet Functions	1	November 7th 04 09:10 PM
Count If Formula	Mimi	Excel Worksheet Functions	0	November 5th 04 11:55 AM
Count rows based on multiple criteria	Murph	Excel Worksheet Functions	1	October 28th 04 07:13 AM

All times are GMT +1. The time now is 05:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us