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 <”” then make P7=”1P”
Or
If H7 <”” then make P7=”2P”
Or
If I7 < “” then make P7=”3P”

And so on.

Just don’t know how to do it.

Thanks in advance,
Ken


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

Does this do it

=COUNTA(G7:O7)&"P"

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sungen99" wrote in
message ...

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 <"" then make P7="1P"
Or
If H7 <"" then make P7="2P"
Or
If I7 < "" then make P7="3P"

And so on.

Just don't know how to do it.

Thanks in advance,
Ken


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

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: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=493117

I get 5P for that, is that not correct?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"sungen99" wrote in
message ...

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:
http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=493117

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: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=493117

Hi!

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

"sungen99" wrote in
message ...

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:
http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=493117

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,"*",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: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=493117

Ken,

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:

="3B"&CHOOSE(MIN(IF(G7:K7<"",--(G7:K7<"")*({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 <g
--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"sungen99" wrote in
message ...

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:
http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=493117