View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Excel Frequency Function?

note re N() function

it converts to number. often useless as excel does it automatically,
but when using array formulas that produce booleans it's used to force the
boolean to 0/1 so the can be summed/counted and frequented :)


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Rob van Gelder" wrote:

Try: http://www.cpearson.com/excel/duplicat.htm