software

Here is what I need to be able to do.

I have 9 columns of clients account numbers as the header.
Each row is a trade that belongs to one of the 9 accounts.

I need to have the 10th column have the account the trade is for
written.

So for example I think I want to do something like this:
If G7 lt;gt;”” then make P7=”1P”
Or
If H7 lt;gt;”” then make P7=”2P”
Or
If I7 lt;gt; “” then make P7=”3P”

And so on.

Just don’t know how to do it.

Thanks in advance,
Ken--
sungen99
------------------------------------------------------------------------
sungen99's Profile: www.excelforum.com/member.php...foamp;userid=9144
View this thread: www.excelforum.com/showthread...hreadid=493117Does this do it

=COUNTA(G7:O7)amp;quot;Pquot;

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;sungen99quot; gt; wrote in
message ...
gt;
gt; Here is what I need to be able to do.
gt;
gt; I have 9 columns of clients account numbers as the header.
gt; Each row is a trade that belongs to one of the 9 accounts.
gt;
gt; I need to have the 10th column have the account the trade is for
gt; written.
gt;
gt; So for example I think I want to do something like this:
gt; If G7 lt;gt;quot;quot; then make P7=quot;1Pquot;
gt; Or
gt; If H7 lt;gt;quot;quot; then make P7=quot;2Pquot;
gt; Or
gt; If I7 lt;gt; quot;quot; then make P7=quot;3Pquot;
gt;
gt; And so on.
gt;
gt; Just don't know how to do it.
gt;
gt; Thanks in advance,
gt; Ken
gt;
gt;
gt; --
gt; sungen99
gt; ------------------------------------------------------------------------
gt; sungen99's Profile:
www.excelforum.com/member.php...foamp;userid=9144
gt; View this thread: www.excelforum.com/showthread...hreadid=493117
gt;

Thanks alot it SORT of works.

The real numbers are actually
3B123
3B454
3B550
3B590
3B625

and so on. so i cant really do it that way. too bad!!!!

any further ideas??

Ken--
sungen99
------------------------------------------------------------------------
sungen99's Profile: www.excelforum.com/member.php...foamp;userid=9144
View this thread: www.excelforum.com/showthread...hreadid=493117I get 5P for that, is that not correct?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;sungen99quot; gt; wrote in
message ...
gt;
gt; Thanks alot it SORT of works.
gt;
gt; The real numbers are actually
gt; 3B123
gt; 3B454
gt; 3B550
gt; 3B590
gt; 3B625
gt;
gt; and so on. so i cant really do it that way. too bad!!!!
gt;
gt; any further ideas??
gt;
gt; Ken
gt;
gt;
gt; --
gt; sungen99
gt; ------------------------------------------------------------------------
gt; sungen99's Profile:
www.excelforum.com/member.php...foamp;userid=9144
gt; View this thread: www.excelforum.com/showthread...hreadid=493117
gt;

Ah. no no- im not explaining it correctly. the actual account numbers
are those. That’s what I want to be displayed. not 1p 2p 3p and so on.--
sungen99
------------------------------------------------------------------------
sungen99's Profile: www.excelforum.com/member.php...foamp;userid=9144
View this thread: www.excelforum.com/showthread...hreadid=493117Hi!

I think you need to completely rewrite your description and include an
example using the actual values. Be VERY specific!

I'm willing to bet that what you want to do is very simple but the
explanation isn't helping.

Biff

quot;sungen99quot; gt; wrote in
message ...
gt;
gt; Ah. no no- im not explaining it correctly. the actual account numbers
gt; are those. That's what I want to be displayed. not 1p 2p 3p and so on.
gt;
gt;
gt; --
gt; sungen99
gt; ------------------------------------------------------------------------
gt; sungen99's Profile:
gt; www.excelforum.com/member.php...foamp;userid=9144
gt; View this thread: www.excelforum.com/showthread...hreadid=493117
gt;

Hi,
If I understand you correctly a single row will only contain one entry
and you want to match that entry with the account number from the
header row. if so then try this:

=INDEX($G$6:$O$6,MATCH(IF(SUM(G7:O7)=0,quot;*quot;,SUM(G7: O7)),G7:O7,0))

as you can see, it is a bit crude maybe one of the MVP's out there as
something better.

HTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=493117
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: www.excelforum.com/member.php...foamp;userid=9144
View this thread: www.excelforum.com/showthread...hreadid=493117Ken,

I think that Biff suggestion of being VERY specific in what it is you are
trying to do is very valid. In the mean time, if you are still using G7:K7
then to return the numbers you gave try:

=quot;3Bquot;amp;CHOOSE(MIN(IF(G7:K7lt;gt;quot;quot;,--(G7:K7lt;gt;quot;quot;)*({1,2,3,4,5}))),123,454,550,590,625)

entered as an array formula with Ctrl Shift Enter not just Enter

I had worked it out so it seemed a waste not to post it lt;ggt;
--
HTH

Sandy

Replace@mailinator with @tiscali.co.ukquot;sungen99quot; gt; wrote in
message ...
gt;
gt; Ah. no no- im not explaining it correctly. the actual account numbers
gt; are those. That's what I want to be displayed. not 1p 2p 3p and so on.
gt;
gt;
gt; --
gt; sungen99
gt; ------------------------------------------------------------------------
gt; sungen99's Profile:
gt; www.excelforum.com/member.php...foamp;userid=9144
gt; View this thread: www.excelforum.com/showthread...hreadid=493117
gt;
Hi!

Try this:

=INDEX(G1:O1,MATCH(9.99999999999999E 307,G2:O2))

Biff

quot;sungen99quot; gt; wrote in
message ...
gt;
gt; Ok does this help?
gt;
gt;
gt; G1 is 3P100 H1 is 3P200 I1 is 3P250 J1 is 3P322 K1 is 3P532 L1 is
gt; 3P555 M1 is 3P560 N1 is 3P667 O1 is 3P800
gt;
gt; As I said the trades run for A1 to A100 or whatever.
gt;
gt; So A1 has Sold 100 in it. and because it was done for the 3P532
gt; account the number of contracts sold (lets say 10) is found in K1
gt;
gt; What I want to do is have P1 show the NAME of the account that did the
gt; trade. In this case P1 would show quot;3P532quot;
gt;
gt; There will never be a case where there are more than one trade per
gt; line.
gt;
gt; Thanks again for the help,
gt;
gt; Ken
gt;
gt;
gt; --
gt; sungen99
gt; ------------------------------------------------------------------------
gt; sungen99's Profile:
gt; www.excelforum.com/member.php...foamp;userid=9144
gt; View this thread: www.excelforum.com/showthread...hreadid=493117
gt;