spill

I think either I'm overthinking things, or this simply isn't possible. Unfortunately the xl2bb addin doesn't seem to like my computer and crashes Excel when I try to run it, so I'll do my best to explain what I have and what I want. Firstly, I have a sequence function that creates a list of...

Hello. I have a spreadsheet that we are using to track vehicle maintenance services. In one column, it lists the mileage from the last service done on that vehicle, which is in another spreadsheet of the same workbook. In another column, I have it listing the service mileage of the previous...

Hi All I have a table similar to below. I am currently using the formula's in Column J. This works well summing Columns B, S, F & H and also allows me to insert more columns in the middle. However when i want to insert rows, i have to drag the formula down. I was wondering if there is a way...

Hello, I am using the below formula in a table. =IF(COUNTIFS(GIS_Points!F3:F742,[Display],GIS_Points!E3:E742,[Location Code])>1,"True","False") I have successfully used this formula in this way in tables in the past. Today excel is generating a #Spill! error. A quick google revels that there...

We can use Excel's new calc engine and dynamic array functions to create a loan amortisation schedule in a way that omits the need to create the correct number of rows or complex formulas to account for the correct number of rows. The formulas go in one row and they spill down to the correct...

Hi. Anyone have any idea why... This array formula "spills", or creates 3 values: $A$1:(A1:A3) However, wrapping it in ROWS does not spill (or creates a simple value of 3): ROWS($A$1:(A1:A3))