Re: Huge "IF" formula help.
- From: "Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 13 Dec 2005 18:50:11 -0000
Does this do it
=COUNTA(G7:O7)&"P"
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"sungen99" <sungen99.1zzrkm_1134499200.8101@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:sungen99.1zzrkm_1134499200.8101@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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?action=getinfo&userid=9144
> View this thread: http://www.excelforum.com/showthread.php?threadid=493117
>
.
- Prev by Date: Re: using a UDF in place of a cond. format, b/c I need 4, not thre
- Next by Date: Don't count header as Row 1?
- Previous by thread: Re: Excel 2003 - Autofilter Question
- Next by thread: Re: Huge "IF" formula help.
- Index(es):
Relevant Pages
|
