what function would I use here?

[Laurence Smith]

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.



--
Larry Smith

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

 

[Pete_UK]

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

 

[Laurence Smith]

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

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

--
Larry Smith

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

 

[Ron Rosenfeld]

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.

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

 

[Pete_UK]

You're welcome, Larry.

Pete