Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Show in Z the last entry from A thru N
I tried using the INDEX formula but I couldn't get it to work. I'm trying to pull over to column Z the last number entry put into any row...so it would look like this: A B C ......... Z 1) 50 12 13 13 2) 10 10 3) 27 93 93 Any help would be appreciated. Thanks, Phillycheese5 -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196 View this thread: http://www.excelforum.com/showthread...hreadid=388139 |
#2
|
|||
|
|||
Try =IF(COUNTA(A1:Y1)=0,"",INDIRECT(CHAR(COUNTA(A1:Y1) +64)&ROW())) Phillycheese5 Wrote: I tried using the INDEX formula but I couldn't get it to work. I'm trying to pull over to column Z the last number entry put into any row...so it would look like this: A B C ......... Z 1) 50 12 13 13 2) 10 10 3) 27 93 93 Any help would be appreciated. Thanks, Phillycheese5 -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=388139 |
#3
|
|||
|
|||
The formula works for some cells but not others...it seems to be pulling the last column in some cases and the second to last in others. Does it matter if I have text in any of the cells to the far left (like in A and B), and then sporadic blank cells? -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196 View this thread: http://www.excelforum.com/showthread...hreadid=388139 |
#4
|
|||
|
|||
The above formula does not work if there are blank cells in between and it will not work once you go pass Column Z (ie. Column AA) I have not been able to come up with something that will suit your application without filling the blank cell with 0. I bet vba can help you tho. Phillycheese5 Wrote: The formula works for some cells but not others...it seems to be pulling the last column in some cases and the second to last in others. Does it matter if I have text in any of the cells to the far left (like in A and B), and then sporadic blank cells? -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=388139 |
#5
|
|||
|
|||
=LOOKUP(9.99999999999999E+307,A1:Y1)
Phillycheese5 wrote: I tried using the INDEX formula but I couldn't get it to work. I'm trying to pull over to column Z the last number entry put into any row...so it would look like this: A B C ......... Z 1) 50 12 13 13 2) 10 10 3) 27 93 93 Any help would be appreciated. Thanks, Phillycheese5 |
#6
|
|||
|
|||
Change Y1 to N1
Aladin Akyurek wrote: =LOOKUP(9.99999999999999E+307,A1:Y1) Phillycheese5 wrote: I tried using the INDEX formula but I couldn't get it to work. I'm trying to pull over to column Z the last number entry put into any row...so it would look like this: A B C ......... Z 1) 50 12 13 13 2) 10 10 3) 27 93 93 Any help would be appreciated. Thanks, Phillycheese5 |
#7
|
|||
|
|||
Aladin, I don't quite understand why the formula works, but it handles the issue. Thanks, Phillycheese5 -- Phillycheese5 ------------------------------------------------------------------------ Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196 View this thread: http://www.excelforum.com/showthread...hreadid=388139 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions | |||
Show the Last entry | Excel Worksheet Functions | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Show a date based on today | Excel Worksheet Functions |