Which Formula?

[Guest]

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.

 

[Roger Govier]

Hi

Try
=LOOKUP(REPT("z",255),A1:A7)

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

Can you comment a post in my thread so we can discuss?

 

[Guest]

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

 

[Guest]

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

 

[Guest]

JLatham, could you help on my problem?

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