what function would I use here?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laurence Smith - 07 Feb 2008 19:11 GMT

In rows 1 to 192 I have a letter in just one of the columns
D,E,F,G,H,or I.

I want to fill in column C so that it will have the letter that is in
column D thru I.

What is the function that I use? I tried =MAX(d2:i2) but that
doesn't work. I suppose the MAX function is for numbers only.

Is it a FIND function or something different?

Thanks in advance.

Signature

Larry Smith

"In this country anyone can grow up to be President.
That's the risk you take."
Adlai Stevenson

Reply to this Message

Pete_UK - 07 Feb 2008 19:18 GMT

You could put this formula in C2 (for example):

=D2&E2&F2&G2&H2&I2

and then copy down for as far as you need. If a cell is empty it will
not contribute to the result, so only the letter will be returned.

Hope this helps.

Pete

> In rows 1 to 192 I have a letter in just one of the columns
> D,E,F,G,H,or I.
[quoted text clipped - 15 lines]
> That's the risk you take."
> Adlai Stevenson

Reply to this Message

Laurence Smith - 07 Feb 2008 19:38 GMT

> You could put this formula in C2 (for example):
>
[quoted text clipped - 26 lines]
> > That's the risk you take."
> > Adlai Stevenson

That's clever as all get out.
Thanks for the idea.

Signature

Larry Smith

"In this country anyone can grow up to be President.
That's the risk you take."
Adlai Stevenson

Reply to this Message

Pete_UK - 08 Feb 2008 00:20 GMT

You're welcome, Larry.

Pete

> That's clever as all get out.
> Thanks for the idea.
>
> --
> Larry Smith

Reply to this Message

Ron Rosenfeld - 07 Feb 2008 21:12 GMT

>In rows 1 to 192 I have a letter in just one of the columns
>D,E,F,G,H,or I.
[quoted text clipped - 8 lines]
>
>Thanks in advance.

Since you know there is only going to be a single entry in that range, you
could use:

=LOOKUP(2,1/(1-ISBLANK(D1:I1)),D1:I1)

which will return the "last" entry in the range.
--ron

Reply to this Message