formula/function question
 

My spreadsheet looks somewhat like this:

1 2 3 4
A 1 15 17 19
B 2 45 98 43
C 3 32 18 24
D
E 3 X X X

Column 1 is count of entries. The spreadsheet is generated by an
outside program and Row E is crucial to the rest of the database. The
data in Row E is referenced in another sheet in the database. The
first cell in the last row is always the total number of entries. The
problem is, the number of entries varies from week-to-week. Is there a
formula/function that I can input that will know how to reference the
last line? When copying and pasting, the references aren't changing as
they should, and I'm left with #REF! all over the place! Thanks for any
advice!


--
wnl2007
------------------------------------------------------------------------
wnl2007's Profile: http://www.excelforum.com/member.php...o&userid=24200
View this thread: http://www.excelforum.com/showthread...hreadid=378536

Would this work for you?:

=INDEX(A:A,MATCH(10^10,A:A),1)

It returns the value of the last numeric item in col A.

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=378536

Yes, that works marvelously... will it work with the entire row being
referenced?


--
wnl2007
------------------------------------------------------------------------
wnl2007's Profile: http://www.excelforum.com/member.php...o&userid=24200
View this thread: http://www.excelforum.com/showthread...hreadid=378536

Yes..with adjustments:
=INDEX(5:5,1,MATCH(10^10,5:5))

That formula will return the last numeric item in row 5.

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=378536

Thanks so much!


--
wnl2007
------------------------------------------------------------------------
wnl2007's Profile: http://www.excelforum.com/member.php...o&userid=24200
View this thread: http://www.excelforum.com/showthread...hreadid=378536