View Single Post
  #10   Report Post  
Bob Phillips
 
Posts: n/a
Default

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