Thanks for the help.

So what would I need to change if I have like 40,000 rows of data? (not
just the 3 when you looked at it).

I tried changing the $G$1:$G$20 to $G$1:$G$40000 and it displayed the
#N/A sign.


--
muchacho
------------------------------------------------------------------------
muchacho's Profile: http://www.excelforum.com/member.php...o&userid=35082
View this thread: http://www.excelforum.com/showthread...hreadid=555662