This is just conditional counting, so there's no need for udfs.

Only if I was a bit smarter <g

"Harlan Grove" wrote:

JMB wrote...
Upon rereading, I am thinking you want the number of unique entries in all
columns combined. You could try a UDF. Paste into an excel module and call
it like
....
"SouthCarolina" wrote:
I am trying to count unique entries across a set of colums. For example,
A C
3 4
2 4
4 7
2 1
1 0

I want the result to be 5 as the number of unique entries. The entries are
not in consecutives column.

Why 5? Col A contains 4 distinct numbers: 3, 2, 4 and 1. Col C contains
two mo 7 and 0. Should the zero not be included? If it should be
included, there are 6 distinct values.

This is just conditional counting, so there's no need for udfs.

=COUNT(1/FREQUENCY((A1:A5,C1:C5),(A1:A5,C1:C5)))