Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.17 seconds.

  1. Replies
    6
    Views
    101

    Something like: =min(100, 'selected...

    Something like:
    =min(100, 'selected cell'/15*100)

    Steve
  2. Replies
    3
    Views
    62

    Is the code located in the ThisWorkbook Object?...

    Is the code located in the ThisWorkbook Object? It needs to be located there.

    Steve
  3. Replies
    4
    Views
    95

    Some formulas must be entered explicitly as an...

    Some formulas must be entered explicitly as an array (ie using the ctrl-shoft-enter). Some formulas implicitly work with arrays (sumproduct, index, etc) so the formula does not explicitly need to...
  4. Are all the rows unhidden in both the copy and...

    Are all the rows unhidden in both the copy and the source?

    Steve
  5. Replies
    3
    Views
    55

    This is not a bad source for the information:...

    This is not a bad source for the information: http://office.microsoft.com/en-us/excel-help/create-a-custom-number-format-HP010342372.aspx

    Steve
  6. Replies
    5
    Views
    142

    The IRR can get a Div/0 error on some occasions...

    The IRR can get a Div/0 error on some occasions if during the iterations the function gets that type of error internally. I think having the values flip too much between positive and negative can do...
  7. Replies
    5
    Views
    142

    Same as before: details of a specific example and...

    Same as before: details of a specific example and how you are calculating it, so we can try and understand the issue.

    Steve
  8. Replies
    5
    Views
    142

    could you provide details of the situation or at...

    could you provide details of the situation or at least an example that we can work through. Also what is an "EAY"?

    Steve
  9. Change the formula in B1 to something like:...

    Change the formula in B1 to something like:
    =COUNTIF(Sheet1!A:C,A1)

    And it will sort the way you expect it to sort. By explicitly adding a sheetname (even if it is sheetname on the sheet), the...
  10. I don't understand the logic to get 0.21 as the...

    I don't understand the logic to get 0.21 as the average. The average of the values from B5:B15 is only 0.17. You can get this average with the array formula (confirm with ctrl-shift-enter):...
  11. Replies
    1
    Views
    70

    At runtime you could determine the number of...

    At runtime you could determine the number of pivottables in the workbook:
    x = 0
    For each wks in Activeworkbook
    x = x + wks.PivotTables.Count
    next
    x = x+1

    and then in your creation code use...
  12. Replies
    8
    Views
    156

    A fill hides the grid. If you follow Retired...

    A fill hides the grid. If you follow Retired Geeks Instructions you can add borders to those cells which will be over the fill and act as a grid.

    Steve
  13. Replies
    5
    Views
    121

    This is cross-posted at...

    This is cross-posted at http://www.eileenslounge.com/viewtopic.php?f=27&t=17311&sid=1eb5c3b7be4bf1d4a149a9d0796a749a. That forum has answers in it, so please go there for any followup and additional...
  14. I am not sure I understand completely. Could you...

    I am not sure I understand completely. Could you elaborate? Is it ONLY the number 1 or is it more general. If a duplicate is found, what should happen to the duplicate cell: clear it, change it to a...
  15. Replies
    13
    Views
    1,023

    There is no need to copy/paste Sub...

    There is no need to copy/paste


    Sub Date_Enter()
    ' Date_Enter Macro
    ActiveCell.Value = Date
    ActiveCell.NumberFormat = "d mmmm yyyy"
    End Sub
  16. Replies
    12
    Views
    294

    An alternative which only requires entering the...

    An alternative which only requires entering the values in 1 place is to use match/index.


    Option Explicit
    Public Function Grade(rng As Range) As String
    'DECLARE AND SET VARIABLES
    Dim rScore...
  17. Will 2 pivot tables work like in the attached? ...

    Will 2 pivot tables work like in the attached?

    Steve
  18. Replies
    13
    Views
    1,023

    If it is more than one cell, you can also use in...

    If it is more than one cell, you can also use in VBA something like:
    range("A1:A15")=date

    If using the shortcut key, you can select the cells you want to change the date of:
    ctrl-;
    Then use:...
  19. Replies
    12
    Views
    294

    Perhaps this example will work. Steve

    Perhaps this example will work.

    Steve
  20. Replies
    4
    Views
    156

    You can essentially accomplish what you have with...

    You can essentially accomplish what you have with your formula with:
    =INT(J2*24+0.5)

    Steve
  21. Replies
    13
    Views
    1,023

    You can use the line of code: ActiveCell = Date...

    You can use the line of code:
    ActiveCell = Date


    You don't need a button, you can just use the shortcut key:
    ctrl-;

    to add the date to the current cell. [ctrl-shift-; (= ctrl-: ) adds the...
  22. Replies
    4
    Views
    93

    I wholeheartedly second RetiredGeek's comments...

    I wholeheartedly second RetiredGeek's comments about Option Explicit.

    Steve
  23. I don't understand your use of the Grand_Total...

    I don't understand your use of the Grand_Total named range. In the file in Aug 14, it was in cell FW$ so I assumed it served some purpose unrelated to the pivot table. But in this one the name is...
  24. Change the ">60" to the respective "60-90",...

    Change the ">60" to the respective "60-90", "90-120", and ">120" as listed in the Pivot table col a.

    Steve
  25. It is your formula, with my addition to give you...

    It is your formula, with my addition to give you the range desired. That part is:

    OFFSET('Pivot Table'!$B$1,MATCH(">60",'Pivot Table'!$A:$A,0)-1,0,1,MATCH("Grand Total",'Pivot Table'!$4:$4,0)-2)
    ...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4