Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.64 seconds.

  1. Re: Formula to list all possible combinations of 4 rows in excel spreadsheet

    There a workbook at https://app.box.com/s/47b28f19d794b25511be with both formula- and VBA-based methods to do that.
  2. Re: Formula for Retirement Eligibility Date - min age (58) and years of service plus age is min of 70

    A correction for leaplings in the UK, Hong Kong, and other places where legal age is attained on Mar 1 in non-leap years:


    =MAX(DATE(YEAR(DoB) + 58, MONTH(DoB), DAY(DoB)),
    MIN(EDATE(DoB, 12 *...
  3. Re: Formula for Retirement Eligibility Date - min age (58) and years of service plus age is min of 70

    That's not what I get:


    A
    B
    C
    1
    DoB
    DoH
    DoR
  4. Re: Formula for Retirement Eligibility Date - min age (58) and years of service plus age is min of 70

    A
    B
    C
    1
    DoB
    DoH
    DoR

    2
    17 Nov 1980
  5. Replies
    1
    Views
    85

    Re: revison cloud add-in

    https://lmgtfy.com/?q=cloud.xlam
  6. Thread: Help!!!!!!!!

    by shg
    Replies
    7
    Views
    394

    Re: Help!!!!!!!!

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
  7. Replies
    6
    Views
    141

    Re: Custom RoundUp function Error

    I'd punt and use the Excel function:


    Public Function RoundtoUp(d As Double, n As Long) As Double
    RoundtoUp = WorksheetFunction.RoundUp(d, n)
    End Function
  8. Replies
    6
    Views
    141

    Re: Custom RoundUp function Error

    That formula/function rounds to specified significant diigits; did you want to round up? Sorry if I misunderstood.
  9. Replies
    6
    Views
    141

    Re: Custom RoundUp function Error

    Via formula:


    A
    B
    C
    D
    1
    Number
    Digits
  10. Re: Inputbox capture OK and Cancel without any data entered

    You're welcome.
  11. Re: Inputbox capture OK and Cancel without any data entered

    Not sure I follow, but perhaps:


    Sub x()
    Dim sInp As String

    sInp = InputBox("Enter something")

    If StrPtr(sInp) = 0 Then
    MsgBox "User pressed Cancel"
  12. Re: I need a way of undoing a macro that deletes all lines

    Worksheets("NPSS_quote_sheet").Copy After:=Worksheets(Worksheets.Count)
  13. Re: replace parentheses and dashes from list of #s

    Sub rn()
    With Range("D:E")
    .Replace " ", ""
    .Replace "(", ""
    .Replace ")", ""
    .Replace "-", ""
    End With
    End Sub
  14. Replies
    3
    Views
    910

    Re: Excel Repair Tool / Recomendation

    Again, you can do the same thing manually; export all the modules (including sheet modules and ThisWorkbook), then save as xlsx, close, reopen, import all the modules, then save as xlsm.
  15. Replies
    3
    Views
    910

    Re: Excel Repair Tool / Recomendation

    Free: http://www.appspro.com/Utilities/CodeCleaner.htm

    It automates what you could do (what I used to do) manually: Export all code, save as an xlsx file, then reinstall the code.
  16. Thread: Oh4fore

    by shg
    Replies
    4
    Views
    180

    Re: Oh4fore

    Like this, for example?


    A
    B
    C
    D
    E
    F
    G
  17. Replies
    2
    Views
    96

    Re: VBA to run a max of once a day

    The code could create a named formula contain the last run date, and not run again until that date passes.
  18. Thread: Set array formula

    by shg
    Replies
    4
    Views
    236

    Re: Set array formula

    You canít enter an array formula longer than 255 characters via VBA in a single go. At http://www.dailydoseofexcel.com/archives/2005/01/10/entering-long-array-formulas-in-vba/, **** Kusleika shows...
  19. Re: Can I Code a macro that has Saved Text descriptions based on a criteria?

    If you were using formulas, it would be a simple VLOOKUP, no?

    So put a lookup table on a (perhaps hidden) sheet and use that in your code.
  20. Replies
    10
    Views
    290

    Re: I need with my friend

    Format E2 as General.

    The formula in C2 should be =DATEDIF(B2, A2, "y")
  21. Replies
    9
    Views
    336

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

    A
    B
    C
    D
    E
    F
    1
    Group
    Qty
    CDF
  22. Replies
    6
    Views
    168

    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.
  23. Replies
    5
    Views
    189

    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
  24. Thread: Time Conversion

    by shg
    Replies
    3
    Views
    233

    Re: Time Conversion

    You're welcome.
  25. Thread: Time Conversion

    by shg
    Replies
    3
    Views
    233

    Re: Time Conversion

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

    5
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4