Which Formula?

T

the dave

Thanks in advance.
Which formula would work here.
There are 7 cells. There will be 1 random text value in one cell, the others
will be blank. I want whichever text value is in the one cell to show up in
another cell.
 
P

pinmaster

Hi,

Here are a couple of ways:

1) =CONCATENATE(A1,A2,A3,A4,A5,A6,A7)

2) =INDEX(A1:A7,MATCH("*",A1:A7))

HTH
Jean-Guy
 
P

pinmaster

Hi,

correction on the second formula:

=INDEX(A1:A7,MATCH("*",A1:A7,0))

if there is no text in A1:A7 it will return #N/A so you can try this instead:

=IF(ISNA(INDEX(A1:A7,MATCH("*",A1:A7,0))),"",INDEX(A1:A7,MATCH("*",A1:A7,0)))

Cheers!
Jean-Guy
 
S

SayWhatAuto

Pinmaster>>>>>> Could that also answer my question in Thread (array, formula,
Constant...........still not sure what to do on that, but I tried your
formula with varied results
 
P

pinmaster

Hi,

Posting in other peoples tread isn't going to help you! Go back to your own
tread and give more details as I'm sure most people don't have a clue what
you're tryiing to accomplish. What result are you looking for? sum? count?
average? ect ect.....!

Good luck
Jean-Guy
 
T

the dave

Thank you all. CONCATENATE worked perfectly. I'll experiment with the other
answers to learn more. thx again.
 
J

JLatham

The CONCATENATE is slick - and you can ignore my log IF() statement in your
other, duplicate, request for help on this one.
 
S

SayWhatAuto

JLatham, could you help on my problem?

JLatham said:
The CONCATENATE is slick - and you can ignore my log IF() statement in your
other, duplicate, request for help on this one.
Click to expand...
 
Top