Excel 2002: How to get the first and last reference in a column ?

Posted to microsoft.public.excel.misc

Mr. Low

external usenet poster

Posts: 505

Excel 2002: How to get the first and last reference in a column ?

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2002 : How to remove the digits from original reference ?	Mr. Low	Excel Discussion (Misc queries)	6	April 13th 07 02:04 PM
Excel 2002: Can Vlookup formula search for data with two reference	Mr. Low	Excel Discussion (Misc queries)	6	March 15th 07 02:48 PM
Can you reference a cell that is sorted in excel 2002?	Dave Green	Excel Worksheet Functions	3	October 22nd 05 11:59 PM
Excel 2002 column limit (IV = 256)	David Billigmeier	Excel Discussion (Misc queries)	0	September 30th 05 09:07 PM
restoring column labels Excel 2002	Paul B	Excel Discussion (Misc queries)	3	April 6th 05 09:29 PM

All times are GMT +1. The time now is 04:54 PM.

Menu

About Us