Thanks Lotus123...
I'll give it a try.

"Lotus123" wrote:


Bleck...not familar with this forum I guess. Not sure why but it gets
rid of all of my extra spaces in my "sample data". As such, here is
what it should look like...

Column A has the three colors with the title Colors
Column B has the title Things with all of the formulas
Column C was empty
Column D has the 3 and 1 in it


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=484165