Thread: how to automatically display data from moving cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default how to automatically display data from moving cells
=LOOKUP(2,1/($B$1:$B$655350),$B$1:$B$65535)

--
Gary''s Student - gsnu200833


"mike CBA" wrote:

how do i automatically display a data that comes from a moving cell in a
column. for example, cellA1 is supposed to display the last entry of
columnBn. entries in column B change daily. Day 1 : cellA1 must display data
in cellB1. day 2: cellA1 displays cellB2. day 3: celllA1 displays cellB3 and
so on. What is the formula?
Reply With QuoteReply With Quote