The formula works for some cells but not others...it seems to be pulling
the last column in some cases and the second to last in others. Does it
matter if I have text in any of the cells to the far left (like in A and
B), and then sporadic blank cells?


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=388139