Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.17 seconds; generated 12 minute(s) ago.

  1. How about this code? Option Explicit Sub...

    How about this code?



    Option Explicit
    Sub AnimateChart()
    Dim rX As Range
    Dim x As Long
    Dim y As Long
    Dim iCols As Integer
  2. Replies
    8
    Views
    131

    There is no attachment. I presume that sum of the...

    There is no attachment. I presume that sum of the COUNTIF of the present and COUNTIF of the excused divided by the total count should work. But without know the setup, it is difficult to be more...
  3. Replies
    15
    Views
    368

    Does this modification to your code work? I just...

    Does this modification to your code work? I just took the total you get and divided it by the number of cells in the range and then convert that number.

    Public Function AvgGrade(rng As Range) As...
  4. Could you elaborate on what you need in excel? I...

    Could you elaborate on what you need in excel? I don't understand what you want the chart to look like and what you want animated. [perhaps you could attach a picture of what you need].

    For...
  5. Replies
    9
    Views
    195

    This question was asked and answered earlier. Is...

    This question was asked and answered earlier. Is there a reason you posted it again?
    If you are looking for a modification of RG's formula:...
  6. Replies
    9
    Views
    195

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

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

    Steve
  7. Replies
    3
    Views
    94

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

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

    Steve
  8. Replies
    4
    Views
    129

    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...
  9. Are all the rows unhidden in both the copy and...

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

    Steve
  10. Replies
    3
    Views
    79

    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
  11. Replies
    5
    Views
    165

    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...
  12. Replies
    5
    Views
    165

    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
  13. Replies
    5
    Views
    165

    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
  14. 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...
  15. 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):...
  16. Replies
    1
    Views
    77

    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...
  17. Replies
    8
    Views
    164

    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
  18. Replies
    5
    Views
    126

    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...
  19. 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...
  20. Replies
    13
    Views
    1,066

    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
  21. Replies
    15
    Views
    368

    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...
  22. Will 2 pivot tables work like in the attached? ...

    Will 2 pivot tables work like in the attached?

    Steve
  23. Replies
    13
    Views
    1,066

    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:...
  24. Replies
    15
    Views
    368

    Perhaps this example will work. Steve

    Perhaps this example will work.

    Steve
  25. Replies
    4
    Views
    169

    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
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4