connecting two cellswith out changing either of them
 

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

connecting two cellswith out changing either of them
 

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

connecting two cellswith out changing either of them
 

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

connecting two cellswith out changing either of them
 

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

connecting two cellswith out changing either of them
 

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