Return Last Value in a Row formula

  • Thread starter Thread starter Txlonghorn76
  • Start date Start date
T

Txlonghorn76

I am using this formula:
=INDEX(1:1,MAX(INDEX(COLUMN(1:1)*(NOT(ISBLANK(1:1))),))) to get the last
non-blank value in my current worksheet. Does anyone know how to use this
formula to get the last rnon-blank value of a different workbook?

Thanks!
 
Just add the path.

Open the other workbook and use your mouse to point to the the source
ranges. This way Excel will add the path for you.

For example...

Start typing the formula: =INDEX(

Now, use the mouse and point to the other workbook and the desired sheet row
1

Excel will add the path for you:

=INDEX([Dates.xls]Sheet1!$1:$1

Then just finish the formula in this manor.
 
I changed the formula to this but it's only giving me the contact of the
first column of row 27. Please help.

=INDEX('[Sept - Daily Doc 08.xls]Daily Individual
Numbers'!$27:$27,MAX(INDEX(COLUMN(27:27)*(NOT(ISBLANK(27:27))),)))


T. Valko said:
Just add the path.

Open the other workbook and use your mouse to point to the the source
ranges. This way Excel will add the path for you.

For example...

Start typing the formula: =INDEX(

Now, use the mouse and point to the other workbook and the desired sheet row
1

Excel will add the path for you:

=INDEX([Dates.xls]Sheet1!$1:$1

Then just finish the formula in this manor.

--
Biff
Microsoft Excel MVP


Txlonghorn76 said:
I am using this formula:
=INDEX(1:1,MAX(INDEX(COLUMN(1:1)*(NOT(ISBLANK(1:1))),))) to get the last
non-blank value in my current worksheet. Does anyone know how to use this
formula to get the last rnon-blank value of a different workbook?

Thanks!
Click to expand...
Click to expand...
 
You have to add the path to every function that references the other
workbook so you need to add the path to the ISBLANK function and the COLUMN
function as well.

Although the path is not needed in the COLUMN function you might want to add
it just so it doesn't lead to confusion.

--
Biff
Microsoft Excel MVP


Txlonghorn76 said:
I changed the formula to this but it's only giving me the contact of the
first column of row 27. Please help.

=INDEX('[Sept - Daily Doc 08.xls]Daily Individual
Numbers'!$27:$27,MAX(INDEX(COLUMN(27:27)*(NOT(ISBLANK(27:27))),)))


T. Valko said:
Just add the path.

Open the other workbook and use your mouse to point to the the source
ranges. This way Excel will add the path for you.

For example...

Start typing the formula: =INDEX(

Now, use the mouse and point to the other workbook and the desired sheet
row
1

Excel will add the path for you:

=INDEX([Dates.xls]Sheet1!$1:$1

Then just finish the formula in this manor.

--
Biff
Microsoft Excel MVP


Txlonghorn76 said:
I am using this formula:
=INDEX(1:1,MAX(INDEX(COLUMN(1:1)*(NOT(ISBLANK(1:1))),))) to get the
last
non-blank value in my current worksheet. Does anyone know how to use
this
formula to get the last rnon-blank value of a different workbook?

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top