Thread: Should it be Index or Offset ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
colwyn colwyn is offline
external usenet poster
  
Posts: 29
Default Should it be Index or Offset ?

=INDEX('2007'!A:N,K2,14)
=OFFSET('2007'!A1,K2-1,13)

Anyone know which of the above works fastest when applied down 50,000+
rows of several spreadsheets?
Thanks.
Colwyn.
Reply With QuoteReply With Quote