| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving data automatically on the same sheet | Excel Discussion (Misc queries) | |||
| Data Moving Cells Between Save and Open | Excel Discussion (Misc queries) | |||
| moving filtered data between worksheets automatically | Excel Worksheet Functions | |||
| Moving data from one sheet to another automatically | Excel Discussion (Misc queries) | |||
| Moving data from multiple cells to one column | Excel Discussion (Misc queries) | |||
Linear Mode
