I still get blanks though and I am looking for a formula to use so that
you can pull the formula down using the filler so that when they add
more data to that column, it automatically fills in.

Thanks though


--
smanuel
------------------------------------------------------------------------
smanuel's Profile: http://www.excelforum.com/member.php...o&userid=16337
View this thread: http://www.excelforum.com/showthread...hreadid=277237