Hi Daniel,
"Daniel.M" wrote in message
...
Also these array formulas (not dependent on any location) :
=SUM(--(0<MMULT(--(Numbers=72),TRANSPOSE(COLUMN(Numbers)*0+1))
*MMULT(--(Numbers=73),TRANSPOSE(COLUMN(Numbers)*0+1))))
MMULT is not an oft used function by me, a bit like SIGN was until Frank
pointed out some uses to me. Must keep it in mind.
or
=COUNT(IF(MMULT(--(Numbers=72),TRANSPOSE(COLUMN(Numbers)^0)),
1/MMULT(--(Numbers=73),TRANSPOSE(COLUMN(Numbers)^0))))
It's always nice to see a solution by a real formula man :-)
Regards
Bob
|