If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find Max and Min based on cell reference | gregork | General Discussion | 3 | February 21st, 2005 12:28 AM |
Having trouble with multi-select list box in Access | brandelfly | New Users | 4 | February 10th, 2005 07:36 PM |
Cell -find number of columns unitl next non-blank cell. | Joe | Worksheet Functions | 2 | May 28th, 2004 08:50 PM |
Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |
Do you have what it takes... | darno | Worksheet Functions | 0 | February 22nd, 2004 08:01 PM |