Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need to find the right-most cell value in a string of cells
In a row of Excel cells, I am wanting to print the last cell. For example
A1=2, A2=55, A3=9. I would like to create a formula within a cell that displays 9 (the last number given. This formula cell would display 9) So on my next row I may have B1=99, B2=9, B3=5, B4=88. So, in this formula cell I would like to display 88. I have about 100 rows with different amounts of data in columns. column a may have 5 cells with data and column B may have 7, while column C may have 2. I need the right-most data to display in an identified cell. I'd like to use this in Excel or create an expression in Access to display the data. |
#2
|
|||
|
|||
Ways to find the last value:-
=LOOKUP(9.99999999999999E+307,A:A) for last numeric entry in a column =LOOKUP(9.99999999999999E+307,1:1) for last numeric entry in a row =LOOKUP(REPT("z",255),A:A) for last text entry in a column =LOOKUP(REPT("z",255),1:1) for last text entry in a row -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "-dc-" wrote in message ... In a row of Excel cells, I am wanting to print the last cell. For example A1=2, A2=55, A3=9. I would like to create a formula within a cell that displays 9 (the last number given. This formula cell would display 9) So on my next row I may have B1=99, B2=9, B3=5, B4=88. So, in this formula cell I would like to display 88. I have about 100 rows with different amounts of data in columns. column a may have 5 cells with data and column B may have 7, while column C may have 2. I need the right-most data to display in an identified cell. I'd like to use this in Excel or create an expression in Access to display the data. |
#3
|
|||
|
|||
Last value in a row...
=LOOKUP(9.99999999999999E+307,1:1) Last value in a column... =LOOKUP(9.99999999999999E+307,A:A) Hope this helps! In article , "-dc-" wrote: In a row of Excel cells, I am wanting to print the last cell. For example A1=2, A2=55, A3=9. I would like to create a formula within a cell that displays 9 (the last number given. This formula cell would display 9) So on my next row I may have B1=99, B2=9, B3=5, B4=88. So, in this formula cell I would like to display 88. I have about 100 rows with different amounts of data in columns. column a may have 5 cells with data and column B may have 7, while column C may have 2. I need the right-most data to display in an identified cell. I'd like to use this in Excel or create an expression in Access to display the data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
Is there a function for "not isblank" (find a cell that has a val. | Excel Worksheet Functions | |||
How to find highest, lowest and last cell in a row? | Excel Worksheet Functions | |||
Need find cell b3 value on another worksheet! | Excel Worksheet Functions |