Need to find the right-most cell value in a string of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Comparison of columns using Conditional Formatting 3
Excel How to find the most common pairs and triplets numbers? 5
Excel VBA 1
Cell reference in formula string displays abbreviated value 2
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Excel How to add numbers in same cell? 2

Back
Top