View Single Post
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

Chip Pearson describes array formulas he

http://www.cpearson.com/excel/array.htm

--
Jim
"frtklau" wrote in message
...

Dear all,

I found some examples of using Array operation like
IF(ISNA(MATCH(...
SUMPRODUCT(--(--A1:A100=5))
more advanced of VLOOKUP & Match.
to get interesting things done very efficiently.

I wonder if there's a reference to web page(s) with Excel file as
example so that I can take as tutorial.

thanx for pointing

Frankie.


--
frtklau