ExcelBanter - how to automatically display data from moving cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to automatically display data from moving cells (https://www.excelbanter.com/excel-discussion-misc-queries/220797-how-automatically-display-data-moving-cells.html)

mike CBA

how to automatically display data from moving cells

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?

Gary''s Student

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?

All times are GMT +1. The time now is 05:33 AM.