Prev: Converting Baseball Innings when Summed
Next: in excel where it says a b c d on top how to shrink that
From: T. Valko on 25 Apr 2010 21:05
You're welcome!

--
Biff
Microsoft Excel MVP


"Malcolm McM" <Malcolm McM(a)discussions.microsoft.com> wrote in message
news:54E71B2F-C78D-4AB5-B8F7-453238B582C2(a)microsoft.com...
> 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
>>
>>
>> .
>>


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