Thanks for the info. I could add more data to my data sheet, but with 20k
rows I was hoping there was a solution to my problem without having to
increase the size of my file.

Greg

"steven1001" wrote:


Try creating a helper column for the margin$ and then use a Calculated
Field to calculate the % as Margin$/Cost$ (or whatever you need to do
to get the correct%)

regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=528399