googled

I have dates in A6:A41. In column B6:B41 I have some check marks. I am trying to find the days between the last two check marks in column B. There will be blank cells between the check marks. I have googled and googled and can't come up with an answer any where. You have been a big help in...

Hi, Can anyone help me to build a button which enables/disables iterative calculations? I'm not really sure how to do it and I have googled it all to no avail.

Hello All - Thanks so much for any ideas you might have on this: I am trying to combine the following statements, each of which seem to work fine on its own, into one statement. Have googled, have searched here - surely I am missing something fundamental. Many thanks for suggestions...

I have tried the Me.Date_Picker.Value = Value in both worksheet start, userform.intialize tried the Now() with no luck. I have googled this and tried everyway but i keep getting errors....

Hi all, Using Excel 2007 I have Googled and Googled and tried to use various examples to help me with this but to no avail. I know nesting isn't ideal, but I need to possibly nest around 10 statements. However I have hit the limit of 7 and can no longer add any more conditions. Below is an...

I want to combine two formulas in an IF statement? I have this formula: IF (Data!CX43="False"), then proceed with this array formula: {=IFERROR(INDEX(Table!$C$2:$C$1000,MATCH(1,(Data!CT45=Table!$B$2:$B$1000)*(Data!CN45=Table!$A$2:$A$1000),0)),0)} otherwise return "0". I've googled the "google'...

I'm using this array formula to return the max date where the primary key matches in 2 different worksheets, and it works fine. {=MAX(IF(Specs!C:C='Info'!C2,Stats!H:H))} I'm trying to get the value in column J on the Stats sheet, for the same line. I've been looking at this for a few hours...

Hello, Hoping someone will be able to help as I've hit a brick wall!! I have created bullet charts to show finance and performance all on one chart for all the organisations we work with. The performance side of things works well but the finance only works if the organisation has either spent...