Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.57 seconds.

  1. Replies
    10
    Views
    165

    Re: I need with my friend

    Format E2 as General.

    The formula in C2 should be =DATEDIF(B2, A2, "y")
  2. Replies
    8
    Views
    181

    Re: VBA Randomly Distribute A,B,C,D,E Evenly

    A
    B
    C
    D
    E
    F
    1
    Group
    Qty
    CDF
  3. Replies
    6
    Views
    84

    Re: Standard deviation of correlation matrix

    Change the formula in those cells so they return blanks on and above the main diagonal. Blanks are ignored by STDEV.
  4. Replies
    5
    Views
    111

    Re: Help converting weird date format

    Messy ...


    A
    B
    C
    115-May
    01 May 2015B1: =--(1 & MID(A1, FIND("-", A1) + 1, 4) & LEFT(A1, FIND("-", A1) - 1))

    216-Mar
  5. Thread: Time Conversion

    by shg
    Replies
    3
    Views
    191

    Re: Time Conversion

    You're welcome.
  6. Thread: Time Conversion

    by shg
    Replies
    3
    Views
    191

    Re: Time Conversion

    c
    d
    e
    f
    4
    8.00
    8.30
    0.50e4: =dollarde(d4, 60) - dollarde(c4, 60)

    5
  7. Replies
    19
    Views
    261

    Re: Unprotect sheet error in VBA

    Worksheets
  8. Thread: % increase.

    by shg
    Replies
    5
    Views
    144

    Re: % increase.

    Or ...


    A
    B
    C
    D
    E
    1
    Site
  9. Thread: % increase.

    by shg
    Replies
    5
    Views
    144

    Re: % increase.

    One way, perhaps:


    A
    B
    C
    D
    E
    1
    Site
  10. Replies
    1
    Views
    56

    Re: Solver: Constraint for values in a range

    SolverOk SetCell:="B94", _
    MaxMinVal:=2, _
    ValueOf:=0, _
    ByChange:="AJ55:AJ84", _
    Engine:=1
    SolverAdd CellRef:="AJ55:AJ84", _
    ...
  11. Thread: LBS OZ formula

    by shg
    Replies
    7
    Views
    108

    Re: LBS OZ formula

    A
    B
    C
    1
    data
    lbs


    2
    112.3
  12. Replies
    15
    Views
    239

    Re: Autofill AAAA-AAAB etc

    UDF?


    A
    B
    1AAAAA1: =ColLtr(ROW() + 18278)

    2AAAB

    3AAAC
  13. Re: Noticed odd new functionality after upgrading to Excel 2016

    You're welcome.
  14. Replies
    1
    Views
    66

    Re: Using Application.OnTime

    You can pass scalar arguments, it's just a little fussy:


    Sub main()
    Range("A1").Value = "Bob"
    Application.OnTime EarliestTime:=Now(), Procedure:=CallString("mySub", "Test", "A1")
    End Sub...
  15. Re: Noticed odd new functionality after upgrading to Excel 2016

    https://www.ablebits.com/office-addins-blog/2019/03/06/flash-fill-excel-examples/
  16. Replies
    3
    Views
    101

    Re: Erasing Arrays after use question

    You're welcome.

    More compactly,


    Function IsArrayInitialized(av As Variant) As Boolean
    On Error Resume Next
    IsArrayInitialized = Not IsError(UBound(av))
    Err.Clear
    End Function
  17. Replies
    6
    Views
    126

    Re: decimals to feet and inches with excel 2002

    Or =B1 & TEXT(C1,"' 0 #/##""")

    Is there a question?
  18. Replies
    3
    Views
    101

    Re: Erasing Arrays after use question

    Function IsArrayInitialized(av As Variant) As Boolean
    Dim i As Long

    On Error Resume Next
    If IsArray(av) Then
    i = UBound(av)
    If Err.Number Then Err.Clear Else...
  19. Replies
    1
    Views
    57

    Re: Does 'On Error Resume Next' reset error?

    It does, but I would use Sub B just because it makes clear what the code is doing.
  20. Re: Scientific Notation Removes values when converting cell to Number

    You're welcome.
  21. Re: Scientific Notation Removes values when converting cell to Number

    The data needs to be imported as Text and remain as text. Numbers in Excel (64-bit IEEE Doubles) only every display a max of 15 significant digits.
  22. Replies
    5
    Views
    227

    Re: Randomly Distributing a Sum Over Cells

    1. Copy the code below from the post
    2. In Excel, press Alt+F11 to open the Visual Basic Editor (VBE)
    3. From the menu bar in the VBE window, do Insert > Module
    4. Paste the code in the window...
  23. Replies
    5
    Views
    227

    Re: Randomly Distributing a Sum Over Cells

    Like this?


    A
    B
    C
    D
    E
    F
    G
  24. Replies
    12
    Views
    276

    Re: creating BINs by altering variables

    You're welcome.
  25. Replies
    12
    Views
    276

    Re: creating BINs by altering variables

    You can't enter the +/-; it comes from formatting.

    Just enter 2.5.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4