Prev: Converting Baseball Innings when Summed
Next: in excel where it says a b c d on top how to shrink that
From: Malcolm McMaster on 24 Apr 2010 20:21
Need some help on a basic question.
I have a list of constantly growing data & I would like the last entered value
in this list to copied to a fixed cell.
EG, if the last entered cell was say line 20 with value "A64" I would like
this value
to be posted to say A1 and as data is entered in line 20 this value would
replace
the contents of cell A1,make sence ?
Any help would be appreciated
From: Malcolm McMaster on 24 Apr 2010 20:38
Sorry the second line 20 should read line 21

"Malcolm McMaster" wrote:

> Need some help on a basic question.
> I have a list of constantly growing data & I would like the last entered value
> in this list to copied to a fixed cell.
> EG, if the last entered cell was say line 20 with value "A64" I would like
> this value
> to be posted to say A1 and as data is entered in line 20 this value would
> replace
> the contents of cell A1,make sence ?
> Any help would be appreciated
From: T. Valko on 24 Apr 2010 20:49
>if the last entered cell was say line 20 with value "A64"

Ok, so I assume the data is TEXT.

Try this...

=LOOKUP("zzzzz",A2:A100)

Adjust for a reasonable end of range A100.

--
Biff
Microsoft Excel MVP


"Malcolm McMaster" <MalcolmMcMaster(a)discussions.microsoft.com> wrote in
message news:C4D27514-B853-41F6-8F1C-064BDCBAB316(a)microsoft.com...
> Need some help on a basic question.
> I have a list of constantly growing data & I would like the last entered
> value
> in this list to copied to a fixed cell.
> EG, if the last entered cell was say line 20 with value "A64" I would like
> this value
> to be posted to say A1 and as data is entered in line 20 this value would
> replace
> the contents of cell A1,make sence ?
> Any help would be appreciated


From: Teethless mama on 24 Apr 2010 20:58
=LOOKUP(2,1/(A1:A100<>""),A1:A100)


"Malcolm McMaster" wrote:

> Sorry the second line 20 should read line 21
>
> "Malcolm McMaster" wrote:
>
> > Need some help on a basic question.
> > I have a list of constantly growing data & I would like the last entered value
> > in this list to copied to a fixed cell.
> > EG, if the last entered cell was say line 20 with value "A64" I would like
> > this value
> > to be posted to say A1 and as data is entered in line 20 this value would
> > replace
> > the contents of cell A1,make sence ?
> > Any help would be appreciated
From: Malcolm McM Malcolm on 25 Apr 2010 18:16
Thanks for the help,

"T. Valko" wrote:

> >if the last entered cell was say line 20 with value "A64"
>
> Ok, so I assume the data is TEXT.
>
> Try this...
>
> =LOOKUP("zzzzz",A2:A100)
>
> Adjust for a reasonable end of range A100.
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Malcolm McMaster" <MalcolmMcMaster(a)discussions.microsoft.com> wrote in
> message news:C4D27514-B853-41F6-8F1C-064BDCBAB316(a)microsoft.com...
> > Need some help on a basic question.
> > I have a list of constantly growing data & I would like the last entered
> > value
> > in this list to copied to a fixed cell.
> > EG, if the last entered cell was say line 20 with value "A64" I would like
> > this value
> > to be posted to say A1 and as data is entered in line 20 this value would
> > replace
> > the contents of cell A1,make sence ?
> > Any help would be appreciated
>
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Converting Baseball Innings when Summed
Next: in excel where it says a b c d on top how to shrink that