Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.13 seconds.

  1. Replies
    4
    Views
    110

    You can automate the filtering but it's hard for...

    You can automate the filtering but it's hard for us to provide useful code without seeing the layout of the workbook.
  2. Replies
    4
    Views
    110

    Filtering the chart data would be the simplest...

    Filtering the chart data would be the simplest thing, since the chart will default to not plotting hidden rows.
  3. Replies
    15
    Views
    559

    So why bother storing it as text, since you lose...

    So why bother storing it as text, since you lose the precision anyway? ;)
  4. Replies
    15
    Views
    559

    Why does it need to be a number? Are you planning...

    Why does it need to be a number? Are you planning to do mathematical operations on it?
  5. Replies
    19
    Views
    916

    If you use CDate when reading from/writing to the...

    If you use CDate when reading from/writing to the cell, it will respect the user's regional settings, which is usually what you want.
  6. Replies
    25
    Views
    1,074

    You can do it directly with data validation...

    You can do it directly with data validation alone. Using the example workbook, select A2:C25, choose Data - Validation, select Custom and enter this formula:...
  7. Replies
    14
    Views
    687

    You have to refresh the pivot table but that's...

    You have to refresh the pivot table but that's all.
  8. Replies
    14
    Views
    687

    I don't think I have 64bit 2010 installed...

    I don't think I have 64bit 2010 installed anywhere. If I find the time I'll set up a VM to see what you have in that file.
  9. Replies
    14
    Views
    687

    2010 or 2013?

    2010 or 2013?
  10. Replies
    14
    Views
    687

    I can't open that file - what version of Excel /...

    I can't open that file - what version of Excel / Power Pivot are you using?
  11. Replies
    14
    Views
    687

    OK. First you need to convert the Database range...

    OK. First you need to convert the Database range into a Table.
    Then I suggest you clean up your data columns so that they contain numbers only not text like "-".
    Then on the Power Pivot tab, click...
  12. Replies
    14
    Views
    687

    If you don't want to use Power Pivot, zeddy's...

    If you don't want to use Power Pivot, zeddy's solution is the simplest. :)
  13. Replies
    10
    Views
    607

    UDF version: Public Function...

    UDF version:


    Public Function UniqueColleges(sColumn As String) As Long
    Dim ws As Worksheet
    Dim oDic As Object
    Dim LastRow As Long...
  14. Replies
    14
    Views
    687

    No it isn't. A calculated field wouldn't work for...

    No it isn't. A calculated field wouldn't work for this because it will sum the columns before performing any other operation, so if you create a column using:
    ='Tonnage w/ grade' * '%Fe'

    it will...
  15. Just: Set BaseWks = ActiveSheet

    Just:

    Set BaseWks = ActiveSheet
  16. Replace: Set BaseWks =...

    Replace:

    Set BaseWks = Workbooks.Add(xlWBATWorksheet).Worksheets(1)
    with this:

    Set BaseWks = ThisWorkbook.Worksheets.Add
  17. If all the numbers are divided by the same...

    If all the numbers are divided by the same denominator, just sort the number column and the ratio will follow suit automatically.
  18. Replies
    5
    Views
    286

    Congrats, one and all. :)

    Congrats, one and all. :)
  19. Replies
    8
    Views
    492

    Just as an alternative UDF: Function...

    Just as an alternative UDF:


    Function TAT(cell As Range) As String
    Dim zValue
    Const clMAX_BAND As Long = 8

    zValue = cell.Value

    If Left$(zValue, 1) = "-" Then
  20. Replies
    12
    Views
    450

    Let's start with the first one and see how we go?...

    Let's start with the first one and see how we go? ;)
  21. Replies
    12
    Views
    450

    Can you post a small database with data that...

    Can you post a small database with data that doesn't work?
  22. Replies
    16
    Views
    1,527

    Me? ;) Not really - I think it's a bug but I...

    Me? ;)


    Not really - I think it's a bug but I confess I've not bothered to report it as the workaround is so trivial, and there may conceivably be a reason for it.
  23. Replies
    16
    Views
    1,527

    SUM ignores text, whereas operators (+ - / *)...

    SUM ignores text, whereas operators (+ - / *) don't, hence you get 0 for SUM("some text") and an error if you try and use a mathematical operator.

    When using a formula in DV you really need to...
  24. Replies
    12
    Views
    450

    What happens if you use: [Last name] =...

    What happens if you use:

    [Last name] = "D''amico"

    instead? (I am assuming the weird quotation marks in your post are not actually in your query)
  25. Replies
    15
    Views
    1,162

    Just on the pointers thing, if you use VBA you...

    Just on the pointers thing, if you use VBA you are probably using pointers most of the time since the default way of passing arguments is ByRef. :)
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4