how to automatically display data from moving cells

M

mike CBA

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Display Name of customer from FILTERED DATA. 3
display text in a cell in a range of cells 1
How to display a date 1
Simple Formula displays "0" 1
Get "AVERAGE" function to ignore empty cells 6
Formula that brings in daily input from a range of cells. 3
First day and Last day of the month to display automatically 1

Top