Ok does this help?


G1 is 3P100 H1 is 3P200 I1 is 3P250 J1 is 3P322 K1 is 3P532 L1 is
3P555 M1 is 3P560 N1 is 3P667 O1 is 3P800

As I said the trades run for A1 to A100 or whatever.

So A1 has Sold 100 in it. and because it was done for the 3P532
account the number of contracts sold (lets say 10) is found in K1

What I want to do is have P1 show the NAME of the account that did the
trade. In this case P1 would show “3P532”

There will never be a case where there are more than one trade per
line.

Thanks again for the help,

Ken


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=493117