Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lowest row with a value?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
lowest row with a value?
Mary,
=INDEX(Sheet2!A:A,MAX(IF(ISNUMBER(Sheet2!A1:A50),R OW(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 "Mary" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
difference between the lowest and next lowest value | Excel Discussion (Misc queries) | |||
determine lowest number in several columns and replace lowest numb | Excel Worksheet Functions | |||
MIN to get three lowest | Excel Worksheet Functions | |||
Range vs. lowest #, 2nd lowest #, 3rd lowest #, etc | Excel Discussion (Misc queries) | |||
How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions |