Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.18 seconds.

  1. You need to test 2 criteria: the absolute date...

    You need to test 2 criteria: the absolute date difference and the item code value in Col B

    In I14, J14 and K14 enter the respective array formulas (confirm with ctrl-shift-enter):

    ...
  2. Replies
    21
    Views
    733

    In my experience, since code can be run without...

    In my experience, since code can be run without .Activate and .Select, it is poor practice to use them Using them complexity to the code, slows it down, and can get disconcerting to the user if the...
  3. [SOLVED] I created the attached using the peltier tip you...

    I created the attached using the peltier tip you posted. A stacked bar chart, Some key items:
    Turn the original data into an XY chart after the other groups have been added and put on sec axis
    Use...
  4. I believe that the data table reads the...

    I believe that the data table reads the formatting of the source data and can not be explicitly set. Unfortunately linked data from closed workbooks seems to only look at the values, not the...
  5. Replies
    2
    Views
    183

    You could tell VBA to ignore the errors of the...

    You could tell VBA to ignore the errors of the Pivot items and turn the error handling back on when they are all finished.

    With ActiveSheet.PivotTables("PivotTable1").PivotFields ("Underwriter")...
  6. Replies
    16
    Views
    2,407

    That was fixed in later versions of the code if...

    That was fixed in later versions of the code if you read further in the thread...

    Steve
  7. Replies
    21
    Views
    733

    Another suggestion is not to activate anything,...

    Another suggestion is not to activate anything, but use explicit references

    Dim wkbDSL as Workbook
    Dim wkbQGP as Workbook

    Set wkbDSL = ActiveWorkbook
    Set wkbQGP =...
  8. Replies
    6
    Views
    726

    The easiest way may be for whatever code you are...

    The easiest way may be for whatever code you are using in the other programs to automatically fill in the hidden column, to also replace the value in the row of the other column. How is that being...
  9. Replies
    7
    Views
    280

    The equation in K9 starts:...

    The equation in K9 starts:
    =IF(SMALL(J10:J14,1)=0,J11,....

    Since small(J10:J14,1)=0 it evaluates to TRUE and puts J11 into the cell (which is 0. It does not to evaluate anything else in the...
  10. I think the easiest way would be to add an...

    I think the easiest way would be to add an additional column in the raw data that contained =ROW() formula to indicate the row.

    Then in Pivot table add a new value field, which is hte mininum of...
  11. Replies
    8
    Views
    341

    [SOLVED] I don't understand. Where are you entering the...

    I don't understand. Where are you entering the value that triggers the selection of a different cell? Also do you want the value in C to cease being the lookup formula and being the value you enter?...
  12. Replies
    4
    Views
    280

    That was an example. you could use any text...

    That was an example. you could use any text string, literal, from a variable, the textbox.value:
    ActiveWorkbook.FollowHyperlink Address:=txtfile1.value

    Steve
  13. Replies
    4
    Views
    280

    You can use the line of code: ...

    You can use the line of code:

    ActiveWorkbook.FollowHyperlink Address:="http://www.radionz.co.nz/news/national/256183/severe-weather-forecast-but-short-lived"

    Steve
  14. 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
  15. Replies
    12
    Views
    544

    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...
  16. Replies
    50
    Views
    1,572

    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...
  17. 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...
  18. Replies
    9
    Views
    284

    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:...
  19. Replies
    9
    Views
    284

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

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

    Steve
  20. Replies
    3
    Views
    211

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

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

    Steve
  21. Replies
    4
    Views
    195

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

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

    Steve
  23. Replies
    3
    Views
    146

    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
  24. Replies
    5
    Views
    259

    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...
  25. Replies
    5
    Views
    259

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