View Single Post
  #1   Report Post  
frtklau
 
Posts: n/a
Default Brush up Array Operation by example


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