thanks for your answer. great!
"Ken Wright" wrote:
=SUMPRODUCT(1/COUNTIF(Range,Range))
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"LatinViolin" wrote in message
...
there are 3 values in a column. they are 2, 2, 3. what formula or
function
do i use to determine how many different values exist in this set. the
answer is 2. there are two different values, 2 & 3. please help
--
cell man
|