Thanks for the help mate. I'm getting NAME error again when I drag them down. I suspect lots of those functions are built-in VBAs/Vstacks that aren't recognised by my excel or am I talking non-sense? Also, is it possible not to have it Spilled and rather have a seperate formula for each cell?