# what function would I use here?

L

#### 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?

--
Larry Smith

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

P

#### 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

L

#### Laurence Smith

Pete_UK said:
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."

R

#### 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?

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

P

#### Pete_UK

You're welcome, Larry.

Pete