Column A is shares, and column J is either realized gains (positive) or
losses (negative). The problem is that I have header rows which repeat
throughout the spreadsheet. But none of the headers have numbers in
column A, so that's why I chose it to use if it was greater than
zero...


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=388045