lowest row with a value?

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I would like to show a list of the most up to date values
on a summary page in my workbook.

The value is always at the bottom of the same column and
it will be the lowest row with any numerical value.

How can I specify in my formula =m(lowestrowwithvalue)?

Thank you

Mary
 
Mary,

=INDEX(Sheet2!A:A,MAX(IF(ISNUMBER(Sheet2!A1:A50),ROW(Sheet2!A1:A50)),1))

Array enter using Ctrl-Shift-Enter rather than just enter. Adjust each
instance of the 50 to give yourself more coverage.

HTH,
Bernie
MS Excel MVP
 

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

Conditional Formating: MAX & MIN 3
I want to sum all data values in a row EXCEPT the lowest two 4
Range Selection - From Lowest 2 Highest Values? 2
Macro storing as a date? 11
Sorting, replacing data 1
Offset and Small functions with blank rows? 0
Find the first lowest value in a column that exceeds $foo 8
Programming question 5

Back
Top