ExcelBanter - Should it be Index or Offset ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Should it be Index or Offset ? (https://www.excelbanter.com/excel-programming/417932-should-index-offset.html)

colwyn

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.

ShaneDevenshire

Should it be Index or Offset ?

Hi,

Try both on your data and see which one is faster, they should be about the
same.

--
Thanks,
Shane Devenshire

"colwyn" wrote:

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

colwyn

Should it be Index or Offset ?

Thanks Shane. I'm in the process of building the spreadsheets so
thought I'd ask first.
Colwyn.

On Oct 1, 3:31*pm, ShaneDevenshire
wrote:
Hi,

Try both on your data and see which one is faster, they should be about the
same.

--
Thanks,
Shane Devenshire

"colwyn" wrote:

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

All times are GMT +1. The time now is 10:32 AM.