Thanks Frank et al, I copied the formula but it is still not working. Coming up with #N/A. :confused
L landmark Oct 7, 2004 #1 Thanks Frank et al, I copied the formula but it is still not working. Coming up with #N/A. :confused
F Frank Kabel Oct 7, 2004 #2 Hi first you ahve to enter this formula as array formula with cTRL+SHIFT+ENTER. Also don't forget do define the 'seq' name
Hi first you ahve to enter this formula as array formula with cTRL+SHIFT+ENTER. Also don't forget do define the 'seq' name