Forum Discussion

JimG12345's avatar
JimG12345
Copper Contributor
Feb 15, 2024

spill errors using =row()

This is an example of the issue I am having. This equation works in pre excel 365 versions =ROW(kW!DE205:DE326)+MATCH(DE46,kW!DE205:DE326,0)-1 but now that I have office 365 I get a spill error on t...
excel
Macros and VBA
office 365
HansVogelaar's avatar
HansVogelaar
MVP
Feb 15, 2024

JimG12345 

Since Excel in Microsoft 365 treats all formulas as array formulas, ROW(kW!DE205:DE326) returns 124 row numbers. Can't you use

 

=ROW(kW!DE205)+MATCH(DE46,kW!DE205:DE326,0)-1

  • JimG12345's avatar
    JimG12345
    Copper Contributor
    Feb 15, 2024
    maybe - I'll try - thanks

Resources