| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highest Value from Excel Formula
I have a formula that goes from B1:B1000-
=IF(Template!$C17="","","EXP_"&'Start Here'!$D$2+ROW(A2)) The formula returns a value if there is a value in another spreadsheet. If not, it is null. My problem is trying to find the last calculated value that is not null and populating the value from the formula on another spreadsheet called "Results". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there an Excel formula to show the highest letter in a row? | Excel Worksheet Functions | |||
| Is there an Excel formula to show the highest letter in a row? | Excel Discussion (Misc queries) | |||
| Is there an Excel formula to show the highest letter in a row? | Excel Discussion (Misc queries) | |||
| 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
| Excel Formula - to calculate highest number from a set of numbers | Excel Worksheet Functions | |||
Threaded Mode
