On 2002-11-01 16:07, Gregc wrote:
Is there an Excel function to return the last record in a row of data. I have dates in a row, 6 columns wide, I want to return the last date in the row.
On 2002-11-01 16:23, Aladin Akyurek wrote:
=LOOKUP(BigNum,A2:F2)
Adjust the range to suit.
On 2002-11-01 17:15, Raider wrote:
On 2002-11-01 16:23, Aladin Akyurek wrote:
=LOOKUP(BigNum,A2:F2)
Adjust the range to suit.
Aladin, i get an #N/A error when i enter the above formula ( with the numeric BigNum).
i don't know, what am i missing ?
LookupBigNum.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ||||||||
2 | 1/2/2001 | 1/3/2001 | 1/4/2001 | 1/5/2001 | 1/6/2001 | |||
3 | ||||||||
4 | ||||||||
5 | 1/6/2001 | |||||||
Sheet1 |
On 2002-11-01 17:33, Raider wrote:
thx, Aladin.
strange but, still the same error. i give it up, its late here....thx again.