You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Mr. Low" wrote in message
...
Hi Valko,

Thanks for your formulas.

All works well.

Best Regards

Low
--
A36B58K641


"T. Valko" wrote:

If the data is text as it appears to be in your sample:

For the first item:

=INDEX(A10:A1000,MATCH("*",A10:A1000,0))

For the last item:

=LOOKUP("zzzzzzzzzz",A10:A1000)

Or:

=LOOKUP(REPT("z",255),A10:A1000)

--
Biff
Microsoft Excel MVP


"Mr. Low" wrote in message
...
Hi,

Let consider the table below:

A B
8
9
10 R216
11 R217
12 R218
13 R220
250 R368
500
1000

I need two formulas at cell A8 and B8 respectively to pick up the
first
and
last refrence in column A.

The number of rows may differs from time to time upon pasting of data
to
this column.

Thanks

Low





--
A36B58K641