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". |
Highest Value from Excel Formula
If you are using VBA try something like this With Sheets("Template") Set MyRange = .Range("C17:C1016") Set c = MyRange.Find(what:="*", _ searchdirection:=xlPrevious, _ LookIn:=xlValues, lookat:=xlPart) If Not c Is Nothing Then Results = "EXP_" & Sheets("Start Here").Range("D" & c.Row) End If End With The find method using the wildcard * and the searchdirection xlPrevious will do what you want. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=197450 http://www.thecodecage.com/forumz |
All times are GMT +1. The time now is 10:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com