You want to extend the formula how? Down the column AN?

Looking at the formula as you've entered it, it appears you can copy
that down as is and it will function in each row the same way. Just
highlight the cell, grab the little box in the lower right corner and
drag it down as far as you want.

Is this what you meant by "extend"?


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48996