Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
I am trying to set up a formula that will return the data in the last cell in
a row. The problem I am having is that the row grows daily. Therefore, if the Cell I want the data to populate in is I3, then my row goes from J3 to infinity or at least Z3 as I add to it. Therefore, I3 should return whatever cell is the last cell in the row with data in it. I have tried an IF statement but it is very long and it only allows me to input upto 8 statements or upto only R3. Any suggestions? Here is the statement that I am using: =IF(R3=0,(IF(Q3=0,(IF(P3=0,(IF(O3=0,(IF(N3=0,(IF(M 3=0,(IF(L3=0,(IF(K3=0,J3,K3)),L3)),M3)),N3)),O3)), P3)),Q3)),R3) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
if a number you desire then just look for one larger than possible in your
data =match(999999999,3:3) -- Don Guillett SalesAid Software "Exceldummy" wrote in message ... I am trying to set up a formula that will return the data in the last cell in a row. The problem I am having is that the row grows daily. Therefore, if the Cell I want the data to populate in is I3, then my row goes from J3 to infinity or at least Z3 as I add to it. Therefore, I3 should return whatever cell is the last cell in the row with data in it. I have tried an IF statement but it is very long and it only allows me to input upto 8 statements or upto only R3. Any suggestions? Here is the statement that I am using: =IF(R3=0,(IF(Q3=0,(IF(P3=0,(IF(O3=0,(IF(N3=0,(IF(M 3=0,(IF(L3=0,(IF(K3=0,J3,K3)),L3)),M3)),N3)),O3)), P3)),Q3)),R3) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
Sorry....I am looking for text. Each cell will have a separate piece of text
data. Basically, if I was setting up a list of people I called and wanted to keep the total list be wanted to populate a cell that showed the last person called then the spreadsheet would look something like this: A B C D E F G 1 Last Person Called: People Called 2 Joe Sara Dave Jen Joe I want B2 to be whatever the last text is in row 2. Therefore if I write "Mike" in cell G2, I want B2 to now say "Mike". Any new suggestions? "Don Guillett" wrote: if a number you desire then just look for one larger than possible in your data =match(999999999,3:3) -- Don Guillett SalesAid Software "Exceldummy" wrote in message ... I am trying to set up a formula that will return the data in the last cell in a row. The problem I am having is that the row grows daily. Therefore, if the Cell I want the data to populate in is I3, then my row goes from J3 to infinity or at least Z3 as I add to it. Therefore, I3 should return whatever cell is the last cell in the row with data in it. I have tried an IF statement but it is very long and it only allows me to input upto 8 statements or upto only R3. Any suggestions? Here is the statement that I am using: =IF(R3=0,(IF(Q3=0,(IF(P3=0,(IF(O3=0,(IF(N3=0,(IF(M 3=0,(IF(L3=0,(IF(K3=0,J3,K3)),L3)),M3)),N3)),O3)), P3)),Q3)),R3) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
Try =LOOKUP(REPT("z",255),J3:IV3) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=563487 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
Neither worked. And Don, I am not even sure what your response means since
it is not an equation. Thanks- "daddylonglegs" wrote: Try =LOOKUP(REPT("z",255),J3:IV3) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=563487 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
I'd try that formula once more.
or this for the whole row: =LOOKUP(REPT("z",255),3:3) Remember to change the 3:3 to the row you want. Exceldummy wrote: Neither worked. And Don, I am not even sure what your response means since it is not an equation. Thanks- "daddylonglegs" wrote: Try =LOOKUP(REPT("z",255),J3:IV3) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=563487 -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
OK...works...thanks for all the help!!
"Dave Peterson" wrote: I'd try that formula once more. or this for the whole row: =LOOKUP(REPT("z",255),3:3) Remember to change the 3:3 to the row you want. Exceldummy wrote: Neither worked. And Don, I am not even sure what your response means since it is not an equation. Thanks- "daddylonglegs" wrote: Try =LOOKUP(REPT("z",255),J3:IV3) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=563487 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) |