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.

Hi

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

--
Regards

Roger Govier


"the dave" <the wrote in message
...
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.

If your text is in Cell A1 and you are wanting your values to be in cells B1,
C1, D1, etc. then all you have to to is type "=$A$1" into cells B1-D1.

If you want B1 to reflect A1, and C1 to reflect B1, then just leave the $
out like "=A1" then drag the cells and hit Ctrl-R to fill, or Ctrl-D if you
are doing this in a column., then it will automatically change A1, B1, C1, so
that each cell reflects the one before it. If you have the $A$1, then you
can still use the Ctrl-R to fill right but it will not change the value so
all cells will reflect what is in A1.

Hope that helps.

"the dave" wrote:

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.

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

"the dave" wrote:

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.

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

"the dave" wrote:

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.

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


"pinmaster" wrote:

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

"the dave" wrote:

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.

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

"SayWhatAuto" wrote:

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


"pinmaster" wrote:

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

"the dave" wrote:

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.

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

"pinmaster" wrote:

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

"SayWhatAuto" wrote:

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


"pinmaster" wrote:

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

"the dave" wrote:

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.

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

"the dave" wrote:

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.

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

"the dave" wrote:

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

"the dave" wrote:

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.

JLatham, could you help on my problem?

"JLatham" wrote:

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

"the dave" wrote:

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

"the dave" wrote:

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.