Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data fill question | Excel Worksheet Functions | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Obscure Question | Excel Discussion (Misc queries) | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |