This formula uses more levels of nesting than you can use in the current file format.

[fabster]

Hi,

Im trying to run this query and getting the above alert. Any help is appreciated

=SUMPRODUCT(MID(0&E66, LARGE(INDEX(ISNUMBER(--MID(E66, ROW(INDIRECT("1:"&LEN(E66))), 1)) * ROW(INDIRECT("1:"&LEN(E66))), 0), ROW(INDIRECT("1:"&LEN(E66))))+1, 1) * 10^ROW(INDIRECT("1:"&LEN(E66)))/10)

Thanks

Fabster