what function would I use here?

  • Thread starter Thread starter Laurence Smith
  • Start date Start date
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?

Thanks in advance.



--
Larry Smith

"In this country anyone can grow up to be President.
That's the risk you take."
Adlai Stevenson
 
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
 
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
Click to expand...

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
 
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.
Click to expand...

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
 
Back
Top