Thread: raversing an array value
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default raversing an array value
one way might be to put in D1

=OFFSET($C$1,-COLUMN()+4+9,-1)

and copy right till M1

then in D3:

=MMULT(A1:A10,D1:M1)

select D3:M12 (or a larger area) and CTRL+SHIFT+ENTER this formula
instead of simply using ENTER

HIH
Reply With QuoteReply With Quote