help

[ianccy]

I paste a column of data in to a workbook column A, and in cell C1 i want to enter a formula such that it equal to the value of the data at the last row of the pasted column, how to write it?

 

[ianccy]

Everytime i would paste data to the column, and the column of data may not have the same no. of rows.

 

[Aladin Akyurek]

On 2002-08-23 07:30, ianccy wrote:
Everytime i would paste data to the column, and the column of data may not have the same no. of rows.

( 1.) Activate Insert|Name|Define.
( 2.) Enter BigNum in the Names in Workbook box.
( 3.) Enter the following in the Refers to box:

9.99999999999999E+307

( 4.) Click OK.

If column A is of numeric type:

In C1 enter:

=INDEX(A:A,MATCH(BigNum,A:A))

If A is non-numeric:

In C1 enter:

=INDEX(A:A,MATCH(REPT("z",90),A:A))