Should it be Index or Offset ?

  • Thread starter Thread starter colwyn
  • Start date Start date
C

colwyn

=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.
 
Hi,

Try both on your data and see which one is faster, they should be about the
same.
 
Thanks Shane. I'm in the process of building the spreadsheets so
thought I'd ask first.
Colwyn.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I automatically copy/paste ? 13
extend selected CurrentRegion results in application or objectdefined error 1004 4
Loop code, capture exceptions, and display pop-up 3
Really need some help with a multi conditional SumProduct 1
Tricky OFFSET routine 4
Help with Index formula 2
How do I automatically insert rows 13
Excel formula to copy/paste formula needed please. 4

Back
Top