Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Can I get a PivotTable calculated field that is the difference of two averages?

    Lets say i have these PovotTable fields. FieldRow, FieldData1 and FieldData2. I put FieldRow in the Row area of the PivotTable, and so data fields will be summarized for each item of FieldRow. I...
  2. Musings on behavior of external references in cells in OneDrive shared workbook on Windows/Android

    I don't really have a question here, just wanted to share this experience, partially as a warning, but if you have any comments on how to improve, please post! Its a bit hard to describe but i'll try...
  3. Is there any way to copy relative references with table formulas.

    Example of what i want: If in cell A3 I have the formula =A1+A2, and if i copy that to another sheet, cell A3, the pasted formula will be exactly "=A1+A2", and it will refer to the cells A1 and A2 in...
  4. Getting valid values for numeric grouping in Pivot Tables

    In a Pivot Table if you put a numeric column in the row area, you can rt. click on any value in the row area, select "group" from the pop-up menu, and Excel will offer you the numeric grouping dialog...
  5. VBA: Refreshing a shared workbook from internet

    I have a workbook on OneDrive that is shared. The workbook is open both on my PC and on my Android phone and i update it from both places.

    When i'm on my PC, i hit the Save button and that...
  6. Re: Can you get the workbook name that a range refers to in VBA?

    It was indeed a context issue. When calling one Sub to another, the Range object gets the workbook context in the caller, not by setting active window in the called Sub.

    I called with this.
    ...
  7. Re: Can you get the workbook name that a range refers to in VBA?

    Thank you. Yes, that does it! Would have saved me alot of time to know that sooner, as i suspected that problem but it took me a long time to solve it in the face of uncertainty.
  8. Can you get the workbook name that a range refers to in VBA?

    I had a VBA debugging problem that i finally solved with difficulty.

    Along the way, i wanted to find out what workbook a Range object was referring to, but it seems that Range does not have a...
  9. can I paste a formula to a new workbook that refers to a sheet in the new workbook, not the old one?

    I have two workbooks with a sheet named "dashb".

    In one workbook I have a formula like this
    =dashb!L2

    If i copy/paste that formula into the second workbook, it comes out like this:...
  10. Re: Any way to get a SUMPRODUCT formula for non-contiguous cells?

    It is true that i somewhat simplified the problem. The example i gave had array1 and array2 having 2 entries each. Actually in my current situation they have 3 entries each. However, i wanted to...
  11. Any way to get a SUMPRODUCT formula for non-contiguous cells?

    What i would like is Sumproduct of array1= A1,A3. Array2 = B1, B3.

    =SUMPRODUCT((A1,A3),(B1,B3)) gives #VALUE . If you try to use {}, SUMPRODUCT will only accept constant numbers, not cell...
  12. Want to convert a number that looks like time to text.

    I have pasted a value that looks like "3:30" into Excel from the web. This number is actually an elapsed time and stands for 3 minutes and 30 seconds of elapsed time. As a number i would like it to...
  13. Re: Getting Excel to recognize elapsed time instead of time.

    The way Excel reads in 12:30:00, as a decimal, is .521 (as a time displays as 12:30:00 PM). The way Excel reads in 6:10.0 as a decimal is .004 (as a time displays as 12:06:10 AM) . And so the...
  14. Re: Getting Excel to recognize elapsed time instead of time.

    I am not sure why you say Excel does not need a concept of elapsed time. What all these values are in fact is elapsed time, in minutes. I do not control their format, as they come from a public web...
  15. Re: Getting Excel to recognize elapsed time instead of time.

    Thanks very much for commenting. I appreciate it! This caused me to look more closely and i see one error in my post...but i still have a type of problem. These are all pasted from a web table (much...
  16. Getting Excel to recognize elapsed time instead of time.

    Trying to paste tabular data into Excel from the web. The web table looks like this.

    <tbody>
    1
    12:30
    12:30
    9:14
    0.74
    0
    453
  17. COLUMN() function not working in this case...why?

    Very mysterious to me that COLUMN() will not work in this case. I illustrate with an example to isolate the problem.

    Fill in V1:V10 on Sheet2 dates 9/1/18, 9/2/18...9/10/18.
    Enter into W1:W10...
  18. Re: VBA - can I stop screen updating when activating different workbooks?

    Thanks very much! I thought i had to activate the book in order to provide "context" for the destination cell. But, as you say, this is not necessary; full context can provided as:...
  19. Re: VBA - can I stop screen updating when activating different workbooks?

    Copying a whole bunch of info from one workbook to another. Maybe it could be designed more efficiently...however, just wanted to write a few quick and dirty lines of code and let the processor do...
  20. VBA - can I stop screen updating when activating different workbooks?

    I have set

    Application.ScreenUpdating = False


    And, it turns off screen updating except for one thing. When i activate a different workbook (with Windows(bo).Activate) the screen changes to...
  21. Re: Formula to find index of first value that meets a condition, starting from bottom of a range.

    Thanks for the help; really appreciate it. Both solutions work, but the one from Aladin is "more general" so will serve my purpose. I made the problem smaller for illustration, but as i use this...
  22. Formula to find index of first value that meets a condition, starting from bottom of a range.

    I want to determine how many rows back (from bottom) of a range that you have to go, to find the first value that meets a condition (condition might be >, <, or =). The values in the range are not...
  23. Is there any way to enable numeric grouping (by range) in this type of PivotTable data?

    In Col A i have expressions that evaluate to a logical (True or False)
    In Col B i have numbers.
    In Col C, there is this formula (and then filled down):
    =IF(A2,B2,"")
    I also tried a variation,...
  24. Is there a way to filter a chart series without Autofilter on the sheet?

    I have an XY series i want to chart, as filtered by another column. This can be done with Autofilter. But, i do not want the sheet data itself to appear as filtered, as for other charts i do not...
  25. Re: Calculated Fields in PivotTables...any trick/workaround to get an "average" to work as the aggregator?

    Thanks...that does work. Appreciate it. Always hate to "mess up the sheet" with dummy type columns, would have been nice to hide it all in a CalculatedField..but oh well, limitations do exist. As an...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4