Recent content by edwardpestian

I think I'm with you, but let me just clarify a couple of items. When the ROW function returns the row number, its actually returning the row number relative to the entire worksheet. For example row 18: Row 18 is row 18 relative to the worksheet, but only row 13 within the range because the...

According to my last post, I was able to get the function to work as expected. I must admit though, I'm not quite following what's happening after the third iF statement. starting with -(index. Could someone please explain to me in plain English? Thanks. ep

Got it working by adding an IF(C5=0,"". Thanks for your help Brad ep =IF($A5=0,"",IF(C5=0,"",IF($A6-$A5>90,-1,-(INDEX($A6:$A$25,MIN(IF(($A6:$A$25<TODAY())*($B6:$B$25<>"ber")*($B6:$B$25<>"iw"),ROW($B6:$B$25)-ROW(A5),"")))-$A5>90))))

Disregard, its still not working. The rows with BER or IW are still being given a value of negative 1. Basically, these rows should be completely disregarded. ep

Got it working like this: each row has to have the value "-15" increment by one. row 15 -15, row 16 -16 etc. But it seems there no way to drag down and have the value "-15" increment by one...

Not quite working. Rows that contain "ber" or "iw" in column B should not be given a value of negative 1. They should simply be disregarded. Thanks again. ep

I have the following IF statement. I'm simply trying to expand the second IF statement within the MIN function to say IF the range b16:b25 <> "ber" or "iw" I'm trying to say that if the date in A16:A25 and "ber" or "iw" is in the range B16:25, then skip to the next date in the range A16:A25...

I have the following array formula that will not work for some reason. {=SUM(IF(C4:C18="TRUE",IF(D4:D18="19:00",1,0)))} I have a checkbox over each cell in the range C4:C18. Each box is associated with the respected cell. So when a box is checked it returns TRUE, and of course, when its not...

Works beautifuly Zack. You are the man! ep

Works perfectly on my Widows box. Can we take it one step further? Only have the function happen when the cell has a blank value. Once the cell has data in it, it would simply function as normal. Thanks all. ep

Actually guys, I'm on a Mac. I've been working on the project from home where I only have a Mac. When I get to work tonight, I'll test in on a Windows box and post an answer as to how things go. Strangely enough, all the other VBA code that I've worked with has worked fine. Thanks again. ep

I put the first bit of code in a standard module, and the second bit of code in the worsheet module. When I click on the cell I get a runtime error 52. File not found user 32. Any ideas. ep

Zach, is this for all cells? I only need it for cells E5, E6 and G6. Do I simple copy and paste this? Thanks. Good to hear from you. ep

My apologies Skip, I didn't mean to "hide my cards." I was simply trying to communicate my need, and didn't think that the code that I already had was pertinant to my delimma. Nothing else is Visible = FALSE?

Each cell has a callout and an autoshape associated with it. I have the following code that hides both shapes once data is placed in the cell. I just want to take it one step further with regards to the previous posts. thanks, ep Private Sub Worksheet_Change(ByVal Target As Range) If...