Showing the nth figure from a list

L

Lynxbci3

Hi,

I have a list data in a column, and on a daily basis i need to mov
down the column to the next item of data. I have a calc that tells m
it is the nth item i need how do i them reference that to show in
cell?

The column is not a fixed length....

eg day 4 i need the 4th item

1234
1542
195487
12456 * This is the data i want to show on my sheet
18547


Thank
 
G

Guest

Hi

Have a look at the OFFSET function. It depends on how your data is laid out
as what arguments you need to use.
 
M

Max

If your column of data as posted
is in Sheet1, A2 down

In Sheet2
--------
Suppose A1 contains: 4

Put in B1: =OFFSET(Sheet1!$A$1,A1,)

B1 will return 12456 - the desired record
 
H

hgrove

Max wrote...
If your column of data as posted is in Sheet1, A2 down

In Sheet2
--------
Suppose A1 contains: 4

Put in B1: =OFFSET(Sheet1!$A$1,A1,)

B1 will return 12456 - the desired record
Click to expand...
...

OFFSET has its uses, and it can be used in this way, but INDEX would b
the better choice for this. Why? Note that Sheet1!A1 is *not* part o
the OP's data range, so many (most) users might not thing there'd b
anything wrong with inserting cells below Sheet1!A1 or moving (*cut
and paste) stuff into Sheet1!A1.

Whenever possible it's best to have indexed references into range
refer to those ranges. So the better formula would be

=INDEX(Sheet1!$A$2:$A$1000,A1
 
M

Max

hgrove > said:
Max wrote...
..

OFFSET has its uses, and it can be used in this way, but INDEX would be
the better choice for this. Why? Note that Sheet1!A1 is *not* part of
the OP's data range, so many (most) users might not think there'd be
anything wrong with inserting cells below Sheet1!A1 or moving (*cut*
and paste) stuff into Sheet1!A1.

Whenever possible it's best to have indexed references into ranges
refer to those ranges. So the better formula would be

=INDEX(Sheet1!$A$2:$A$1000,A1)
Click to expand...

Thanks for insights, Harlan !
 
Top