Excel Formula issue

  • Guest, it's time once again for the massively important and exciting FoH Asshat Tournament!



    Go here and give us your nominations!
    Who's been the biggest Asshat in the last year? Give us your worst ones!
ToeMissile

ToeMissile

Pronouns: zie/zhem/zer
<Gold Donor>
3,416
2,231
So I have this formula in an Excel template that has been working fine, but I've apparently done something to prevent it from working.

The idea is for each unique lease number to populate down the list.

If I replace the T_EqList[Lease Number] with a reference to location of the table/column (Sheet!E2:Ex), it works. Also, calls to the same table/column in other formulas work fine.

I am making sure this is entered as an array formula after typing it in/editing (ctrl+shift+enter)

Any ideas?

rrr_img_100437.png
 
Sir Funk

Sir Funk

Molten Core Raider
1,251
155
Have you moved the Lease Number column around in your table, by chance? I know if you move column locations around inside of a table that you have to manually change the column's reference to the new position.
 
ToeMissile

ToeMissile

Pronouns: zie/zhem/zer
<Gold Donor>
3,416
2,231
Haven't changed the column order. I ended up finding a slightly older version of the file where the formula is working. Can't tell what's different when comparing the two files.
 
You must log in or register to reply here.