Is the data in a specific range? or does this change? Will probably be
a loop that needs to be created. and set the loop when statement to
your data range.

jerrystan Wrote:
It will always be column A, but I don't want to add the formula to any
blank rows below where my data is. Thanks.


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=482355