Forum

I've relooked at this and entered the formula as an array formula and I do get a resolved answer but its the wrong value from 620 rows further down th...

Many thanks Anders, I thought I’d seen somewhere that INDEX is clever enough to know when its an array and therefore Ctrl+shift+enter not needed. S...

Thanks Catalin for your help Your expnation makes sense as thats how I understood it worked - however something different is happening with my data...

Thanks for the reply which makes sense but I'm still having a dilema on how to structure the data properly. My original thoughts were to set up an ...

Thanks - that makes sense for the source data, but would the analysis table simply add a row when a row was added to the source data?