Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.22 seconds.

  1. Re: Converting number to minutes and deleting text

    Not quite clear how many variants you have - hours, no minutes, non-time values interspersed in Col D etc... the below is a rough and ready approach



    Sub Example()
    With Sheets("Sheet1")
    ...
  2. Replies
    5
    Views
    181

    Re: change "two points" by a comma

    Given the above perhaps:



    B2:
    =TEXT(A2,"[hh],mm")


    Assuming you want as a literal string else adjust format of A2 to [hh],mm
  3. Re: Need formula that will return a value from a range with blank cells

    Not altogether clear to me how complicated this really is? If you're saying you need to find the first non-null string in Col A that occurs between the first and last "A" reference in Col B and where...
  4. Replies
    20
    Views
    1,907

    Re: Count Unique IDs

    I'd be inclined to add just a handler around the numeric iteration - obviously some fairly significant assumptions were made regards data types etc...



    Function UniqueIDs(rngStr As Range) As...
  5. Re: Count If Multiple Tabs and Multiple Criteria

    x-posted: http://www.excelforum.com/excel-general/827876-countif-multiple-criteria-and-multiple-sheets.html
  6. Replies
    20
    Views
    1,907

    Re: Count Unique IDs

    There will be more elegant methods but as a starting point:

    <b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt;...
  7. Replies
    7
    Views
    446

    Re: Add column to table with Subtotals

    Another alternative:



    E2:
    =IF($C3=$C2,"",SUM($D$2:$D2)-SUM($E$1:$E1))
    copied down
  8. Replies
    2
    Views
    254

    Re: Search that returns Range

    A number of alternative methods, in the below I have simplified the example with a single sheet.

    <b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0"...
  9. Replies
    6
    Views
    488

    Re: Work Weeks in Month

    I'll echo that... I knew I should have said 95%...
  10. Re: Drag and copy with auto-Cell reference adjustment?

    Perhaps:


    ...
  11. Re: Drag and copy with auto-Cell reference adjustment?

    You might wrap within a SUBSTITUTE



    =SUBSTITUTE(CELL(....),"$","")
    confirmed with CTRL + SHIFT + ENTER


    (per earlier formula XL2007 or above is assumed)
  12. Replies
    14
    Views
    763

    Re: Find and return cell address

    question repeated:

    http://www.mrexcel.com/forum/showthread.php?t=596385
  13. Re: Drag and copy with auto-Cell reference adjustment?

    If you wish to retrieve the first cell containing a given value then the original is slightly flawed if one allows for duplicates

    Assume A2 and B1 contain A13 - the original would return A1 as...
  14. Replies
    10
    Views
    616

    Re: Cut numbers off before a decimal

    The function pulls the left n characters from the original string

    n is determined by position of first period delimiter in the string less 1

    The string is appended with a trailing period so as...
  15. Replies
    6
    Views
    488

    Re: Work Weeks in Month

    I'm not very good at coming up with elegant date functions, however, the below might work ?


    ...
  16. Re: How to replace the letters in a cell with defined numbers

    Excel is not very good at multiple text substitution... I suspect you would be better off reverting to a User Defined Function, eg:



    Function CONVCODE(rngCode As Range, rngKey As Range) As...
  17. Replies
    10
    Views
    616

    Re: Cut numbers off before a decimal

    If you need formula for sake of being dynamic:



    B2:
    =LEFT($A2&"",FIND(".",$A2&".")-1)
    copied down
  18. Re: How do I disable cells based on a previous input

    Far from elegant but perhaps something along the lines of:



    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim rngInterest As Range, rngCell As Range
    Dim strCols As String
    ...
  19. Replies
    5
    Views
    1,352

    Re: absolute and relative table nomenclature

    The above is not entirely accurate.

    Table references are Relative when formulas are dragged (e.g. Fill Handle is used)
    Table references are Absolute when literally Copied (Ctrl + C etc)

    I...
  20. Replies
    45
    Views
    2,174

    Re: Finding highest drop in value

    If you're opting for helpers I might suggest something along the lines of:


    <b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial;...
  21. Re: Dynamic hyperlink in the same cell as the data?

    I think I missed a fundamental point... if you're the 1234 appears in the cell you wish to be a Hyperlink then you would need to use VBA to convert ... else, as you say, have the hyperlink in a...
  22. Re: Help with VBA SQL Query and storing Results into Variables

    You can make your routines a little more flexible but in terms of the specifics of your query perhaps:



    Public Sub ADO_Recordset()
    Dim c As ADODB.Connection
    Dim r As ADODB.Recordset
    ...
  23. Replies
    1
    Views
    325

    Re: Validation list display

    Create the list as follows:

    In A1 type 1 - apply Custom Cell Format to A1 of: "Yes"
    In A2 type 0 - apply Custom Cell Format to A2 of: "No"
    repeat if nec. for other options

    Create your...
  24. Replies
    4
    Views
    546

    Re: VLOOKUP problem (N/A error)

    raulduke,

    Welcome to the Board. If you opt to cross post the same question on different message boards please reference accordingly:
    ...
  25. Re: Dynamic hyperlink in the same cell as the data?

    Perhaps:



    =HYPERLINK("www.example.com"&REPT("/CSIssue_View.asp?IssueNbr="&$A1,$A1<>""))
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4