Thanks for the kind words. The formula used was Visual Basic code and it's a whole other bear it can use the regular worksheet functions but basically makes it possible to do anything with Excel ( I havent found something Excel cant do it yet)

Thanks please feel free to mark as solved.