Search:

Type: Posts; User: mbarron; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds; generated 43 minute(s) ago.

  1. Replies
    2
    Views
    610

    Try this: =SUMPRODUCT(--(B1:H1="Y"),A1:G1)

    Try this:
    =SUMPRODUCT(--(B1:H1="Y"),A1:G1)
  2. Replies
    2
    Views
    1,169

    This would add the values in the B column where...

    This would add the values in the B column where the corresponding rows in the A column start with the word Apple

    =SUMIF(A2:A100,"=Apple*",B2:B100)
  3. Replies
    5
    Views
    2,527

    I'm betting you are using the Instant search. It...

    I'm betting you are using the Instant search. It defaults to 10 and there is no way to change it to anything higher (well, technically you can change it, but Google changes it back to 10). It's for...
  4. Replies
    5
    Views
    764

    Change the drop down for Firefox Will to "Use...

    Change the drop down for Firefox Will to "Use custom settings for history"
  5. Replies
    5
    Views
    764

    That is odd... I'm using 3.6.12 as well and see...

    That is odd... I'm using 3.6.12 as well and see it the cookie options on the Privacy 'tab' under Tools / Options
    [attachment=90544:mmm cookies.jpg]...
  6. Replies
    3
    Views
    1,102

    The macros are the same. The advantage to mine is...

    The macros are the same. The advantage to mine is that you don't have to explicitly assign a range as in the examples at the site you have linked.
  7. Replies
    5
    Views
    818

    Perhaps he is referring to this: ...

    Perhaps he is referring to this:

    [attachment=90314:beta.jpg]
  8. Replies
    3
    Views
    1,102

    You can use the following macro: Sub...

    You can use the following macro:


    Sub makeupper()
    Dim r As Range
    Application.ScreenUpdating = False
    For Each r In ActiveSheet.UsedRange
    r = UCase(r)
    Next
    Application.ScreenUpdating =...
  9. Thread: Gmail

    by mbarron
    Replies
    2
    Views
    1,712

    Depending on your Browser.... In FireFox...

    Depending on your Browser....

    In FireFox
    Change the Drop Down, the one that shows Reply, to Show Original. Right click on the message and choose Save Page As..., change the file type to All...
  10. Do you have Javascript enabled in FF? Are you...

    Do you have Javascript enabled in FF? Are you using an Add-In such as NoScript?
  11. Replies
    2
    Views
    503

    Try wrapping the code in: DoCmd.Echo False ...

    Try wrapping the code in:

    DoCmd.Echo False

    your code goes here

    DoCmd.Echo True
  12. Thread: Input Mask

    by mbarron
    Replies
    2
    Views
    554

    The Format of the field is where you would set...

    The Format of the field is where you would set how the time is displayed. Set the Format to hh:nn:ss. Your input mask would be 99:00:00
  13. Replies
    2
    Views
    472

    For an explanation - go to the CoolIris Blog...

    For an explanation - go to the CoolIris Blog
  14. Thread: Jeezball??

    by mbarron
    Replies
    2
    Views
    2,919

    I was able to download Jezzball from here...

    I was able to download Jezzball from here. Click on the picture to access the download.

    Thanks for reminding me of this great time waster.
  15. Replies
    6
    Views
    754

    Then using: =AVERAGE('Belt 4'!C3,'belt...

    Then using:

    =AVERAGE('Belt 4'!C3,'belt 3'!C4,'belt 3'!C3,'belt 3'!C12,'belt 3'!C13)
    will work.
  16. Replies
    6
    Views
    754

    Did you change the formula to: ...

    Did you change the formula to:


    =AVERAGE('Belt 4'!C3,'belt 3'!C4,'belt 3'!C3,'belt 3'!C12,'belt 3'!C13)

    I'm guessing you have

    =AVERAGE('Belt 4'!C3+'belt 3'!C4+'belt 3'!C3+'belt 3'!C12+'belt...
  17. What you are asking is nearly impossible,...

    What you are asking is nearly impossible, especially with a large group of numbers.

    Consider, for example, the sum of 6 with possible addents of 1, 1, 2, 2, 3, 3. There are 10 different...
  18. Replies
    5
    Views
    2,624

    Can you post a sample of the workbook? Since it's...

    Can you post a sample of the workbook? Since it's an issue with the rows being hidden or their height, you can delete all of the data.
  19. Replies
    1
    Views
    1,506

    You can use something like: The value in...

    You can use something like:



    The value in A1 will be a value and not the formula.
  20. Replies
    2
    Views
    501

    The error occurs when the DeleteRowsWB macro is...

    The error occurs when the DeleteRowsWB macro is run. When the macro deletes the rows, the change event macro fires. Wrap the DeleteRowsWB in:
    Application.EnableEvents=False and...
  21. Replies
    2
    Views
    474

    As long as the format of the text is as you've...

    As long as the format of the text is as you've shown - 3 character month followed by the day a comma and 4 digit month, you can use the following formula.

    CDate(Trim(Left([dateText],12)))

    or...
  22. Replies
    5
    Views
    600

    Use this code assigned to the the...

    Use this code assigned to the the Worksheet_Change event:


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Columns(6)) Is Nothing Then
    If...
  23. Replies
    4
    Views
    5,010

    Chuck, I cannot find anywhere within Excel 2003...

    Chuck,
    I cannot find anywhere within Excel 2003 to be able to insert the fields such as the author or other document properties into the footer.

    I do see the functionality in Word, but not Excel....
  24. Replies
    5
    Views
    600

    You can do this with a formula and conditional...

    You can do this with a formula and conditional formatting.
    In G2

    =IF(COUNTA(A2:F2)=6,IF(COUNTIF(A2:F2,A2)=6,"Yes","No"),"")

    For the conditional formatting, with G2 selected, assign this...
  25. Here is a variation - It allows for nonWk sheets...

    Here is a variation - It allows for nonWk sheets existing in the same workbook.


    Sub btnNewWeek_Click()
    Dim i As Integer, iLstWeek As Integer

    For i = 1 To Sheets.Count
    If...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4