Search:

Type: Posts; User: dguillett@gmail.com; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. IF you change the format of your v10:z10 from...

    IF you change the format of your v10:z10 from MERGE to CENTER ACROSS and use the formula, AS WRITTEN, and then apply the CSE it works just fine for the parameters given........
    See attached.
  2. Please tell us WHY it didn't work and what more...

    Please tell us WHY it didn't work and what more you expect it to do????? A larger sample might be good or the ACTUAL file.
  3. http://www.rondebruin.nl/win/s3/win026.htm

    http://www.rondebruin.nl/win/s3/win026.htm
  4. This is the way a max(if formula works. To make...

    This is the way a max(if formula works. To make it easier I have defined names for the columns (see formulas>name manager) in the attached. And, this formula is an array formula that must be entered...
  5. You should have told us that in the first place...

    You should have told us that in the first place and provided an example file showing EXACTLY what you wanted. Do so.
  6. Replies
    10
    Views
    247

    You really need to know that we do not read...

    You really need to know that we do not read minds. So, fully explain what you need with a file and examples along with your excel version.
  7. I added a couple of simple lines to the code ...

    I added a couple of simple lines to the code

    Sub GetDifferenceLastDayLessFirstDay()
    Dim lr As Long
    Dim i As Long
    Application.ScreenUpdating = 0
    Columns(3).Clear
    lr = Cells(Rows.Count,...
  8. Not really. Read my reply again.

    Not really. Read my reply again.
  9. Replies
    10
    Views
    247

    You may not be able to get "egg in your beer"...

    You may not be able to get "egg in your beer" about partial transparency but you can still have borders. Bring up the picture toolbar and play. See attached. How about you attach yours.......
  10. Replies
    10
    Views
    247

    right click lower right of shape until menu...

    right click lower right of shape until menu
    select format shape>select fill>transparency.
  11. I don't see how the att workbook explains what...

    I don't see how the att workbook explains what you want. Provide an example of your source workbook(s) and an example of how it would look on the destination sheet.
  12. Here is a macro that will do it fast with a for i...

    Here is a macro that will do it fast with a for i loop

    Sub GetDifferenceLastDayLessFirstDay()
    Dim lr As Long
    Dim i As Long
    Application.ScreenUpdating = 0
    Columns(3).Clear
    lr =...
  13. Replies
    5
    Views
    210

    http://office.microsoft.com/en-us/visio-help/inser...

    http://office.microsoft.com/en-us/visio-help/insert-a-check-mark-symbol-HA001116601.aspx
  14. Confusing, OP said "What I need is: For month...

    Confusing, OP said

    "What I need is:
    For month and year, last number minus first number
    or
    =SUM(IF(MONTH($A:$A)=9,IF(YEAR($A:$A)=2014, last number in column [or last date entered] for that...
  15. What is the correct answer and what is the logic....

    What is the correct answer and what is the logic. If you get the max for Jan @ 197 and the min for Jan at 55 and subtract, you get 142. Feb=115, etc
  16. This array formula entered using CSE will find...

    This array formula entered using CSE will find the max and the min and sub tract min from max It is ONE formula in ONE cell
    ...
  17. This will find the first item in col B for the...

    This will find the first item in col B for the earliest date in Col A.
    =MIN(IF(MONTH($A$2:$A$80)=MONTH(A3),$B$2:$B$80))
    This is an array formula that must be entered using Ctrl+shift+enter instead...
  18. or using cells...

    or using cells
    lr=cells(rows.count,1).end(xlup).row+1

    or special cells last row on sheet

    lr = Cells.SpecialCells(xlCellTypeLastCell).Row
  19. You could also use specialcells to find the last...

    You could also use specialcells to find the last cell and use that row. Column doesn't matter.

    lr = Cells.SpecialCells(xlCellTypeLastCell).Row
  20. [SOLVED] Copy this to your n1>change c! to...

    Copy this to your n1>change c! to Composites!>copy down
    ...
  21. Replies
    2
    Views
    114

    Should get you started. Sub MailOnDate() If...

    Should get you started.
    Sub MailOnDate()
    If Date = "9/25/2014" Then
    MsgBox "Hi"
    'do your thing
    End If
    End Sub
  22. [SOLVED] Stuart, I'm sure you can do what you want with a...

    Stuart, I'm sure you can do what you want with a FIND or FINDNEXT macro. You have provided a sheet but no examples of the end desire.

    Are you saying you want to look in all other sheets for the id...
  23. Confusing. Provide file with examples

    Confusing. Provide file with examples
  24. correct this for word wrap where month/year in a...

    correct this for word wrap where month/year in a column H and formula in col I
    =SUMPRODUCT((YEAR($A$2:$A$2000)=YEAR(H2))*
    MONTH($A$2:$A$2000)=MONTH(H2))*$B$2:$B$2000)

    01/2010 630
    02/2010 1231...
  25. I would write a custom function called a UDF...

    I would write a custom function called a UDF (user defined function) where you would only have to
    =DaysCount(a1,b1). This is macro code.
Results 1 to 25 of 101
Page 1 of 5 1 2 3 4