Prev: dates not recognised
Next: Return values from a list that sum to a known value
From: casinel1 on 27 May 2010 18:08
Need some help here. I am using excel 2007 and I am merging cells - I cannot
figure out a formula to give me the text in 91 columns below the previous
text.

Ex. Cell G7 = Unbalanced
Cell G95 = NVAA

What formula can I use to get me the text out of cell G95 using cell G7. Ex
G7+what= NVAA(G95). Thanks.

From: Bob Phillips on 27 May 2010 18:14
Maybe

=OFFSET(G7,88,0)

--

HTH

Bob

"casinel1" <casinel1(a)discussions.microsoft.com> wrote in message
news:EEBF975E-7D02-48DC-836C-5E7A11C27389(a)microsoft.com...
> Need some help here. I am using excel 2007 and I am merging cells - I
> cannot
> figure out a formula to give me the text in 91 columns below the previous
> text.
>
> Ex. Cell G7 = Unbalanced
> Cell G95 = NVAA
>
> What formula can I use to get me the text out of cell G95 using cell G7.
> Ex
> G7+what= NVAA(G95). Thanks.
>


 | 
Pages: 1
Prev: dates not recognised
Next: Return values from a list that sum to a known value