I am trying to find a way to connect two cells together when one is text and
the other is numbers so when i am looking for the largest number in a string
of cells the two connected cells are placed in the answer cell ie:
{B3:I3=text and B36:I36=numbers}
In the answer cell D40 the largest = either B3/B36 or C3/I36 and so on ?
Hope this isn't too confusing

Thanks in advance

Hope this isn't too confusing
:-)

"Diesel" wrote:

I am trying to find a way to connect two cells together when one is text and
the other is numbers so when i am looking for the largest number in a string
of cells the two connected cells are placed in the answer cell ie:
{B3:I3=text and B36:I36=numbers}
In the answer cell D40 the largest = either B3/B36 or C3/I36 and so on ?
Hope this isn't too confusing

Thanks in advance

What does connecting 2 cells mean?

Dave Ramage wrote:
Hope this isn't too confusing
:-)

"Diesel" wrote:

I am trying to find a way to connect two cells together when one is text and
the other is numbers so when i am looking for the largest number in a string
of cells the two connected cells are placed in the answer cell ie:
{B3:I3=text and B36:I36=numbers}
In the answer cell D40 the largest = either B3/B36 or C3/I36 and so on ?
Hope this isn't too confusing

Thanks in advance

connect them as in linking two caells together without changing either of the
cells info

"davegb" wrote:

What does connecting 2 cells mean?

Dave Ramage wrote:
Hope this isn't too confusing
:-)

"Diesel" wrote:

I am trying to find a way to connect two cells together when one is text and
the other is numbers so when i am looking for the largest number in a string
of cells the two connected cells are placed in the answer cell ie:
{B3:I3=text and B36:I36=numbers}
In the answer cell D40 the largest = either B3/B36 or C3/I36 and so on ?
Hope this isn't too confusing

Thanks in advance

Diesel wrote:
connect them as in linking two caells together without changing either of the
cells info


What would that accomplish? I don't know of anyway to do that because I
don't know what it would mean.

"davegb" wrote:

What does connecting 2 cells mean?

Dave Ramage wrote:
Hope this isn't too confusing
:-)

"Diesel" wrote:

I am trying to find a way to connect two cells together when one is text and
the other is numbers so when i am looking for the largest number in a string
of cells the two connected cells are placed in the answer cell ie:
{B3:I3=text and B36:I36=numbers}
In the answer cell D40 the largest = either B3/B36 or C3/I36 and so on ?
Hope this isn't too confusing

Thanks in advance