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
> >
> >