Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Re: Creating a Compound Table for a Variable Term

    50*(0.8^3)

    =B4*(B8^b9)
  2. Replies
    7
    Views
    80

    Re: Cannot Sum Days, Hours and Minutes

    You can evaluate the results to text.

    =INT(A1)+0&" Days " & TEXT(MOD(A1,1),"h") & " Hours and " & TEXT(MOD(A1,1),"m") & " Minutes"
    Where A1 would be the the SUM() of time values
  3. Replies
    7
    Views
    80

    Re: Cannot Sum Days, Hours and Minutes

    The trick isn't adding the values, but making sure the formatting displays the days part. Exceeding 31 days in time/date formatting restarts due the months!
    Even your sample is subject to this...
  4. Re: Counting average number of unique outputs

    AVERAGE of COUNTS is not a built in feature of Pivot Tables. You will have to go to PowerPivot/DAX formulas to feed a Pivot Table via data model.
    You could also go old-school with an array-formula...
  5. Re: Filtered dataset / sort / hidden columns

    If the hidden columns are in the range of data being filtered, yes. Or if the range has been converted to a Table, yes.
  6. Replies
    10
    Views
    130

    Re: Time and Duration

    In Excel, the TIME portion of a date/time value is the decimal part of a number representing the number of days since "Jan 0, 1900"
    So any conversions must consider that in the...
  7. Re: Excel Automatically Changing General to Date

    I would bet its PAX.
    At some point the cell, or column is given a date value or a date format to the cell or column which Excel is then trying to maintain to be "helpful"
  8. Replies
    2
    Views
    87

    Re: 10% Time Improvements

    Decimal time...??

    =TIME(0,7,5)*0.9
    Format as "H:MM:SS" or "MM:SS"


    TIME(0,C2,D2)*0.9
  9. Re: Can pivot tables in worksheet be shared in another excel workbook and changes dynamically?

    Use a Query to link the data and have the single Pivot Table in that.
  10. Replies
    4
    Views
    111

    Re: change column headings to inches

    You need to in Page Layout View
  11. Replies
    4
    Views
    180

    Re: Power query Module vba Codes

    Yeah. No, its not going to happen that way. It is unlikely you have the Power Query for those versions as the Professional Plus version of excel is likely what you don't have to even install the...
  12. Replies
    5
    Views
    145

    Re: File size issue

    just making sure it wasn't over 15.
    For me, when a "number" is not really a number like credit card "numbers" I treat as Text and make sure the formatting remains or is converted to text. Or when...
  13. Replies
    5
    Views
    145

    Re: File size issue

    Merch Number. How many characters in this number?
  14. Replies
    5
    Views
    145

    Re: File size issue

    First, no. Some limitation differences between 32-bit Excel and 64-bit Excel do exist, but known that I can think of to generate any inconsistencies.
    However, with any large set of data and seeking...
  15. Replies
    5
    Views
    88

    Re: Using Timeline Slicer

    It sounds like Excel is trying to be "Helpful"
    Right Click on those "date" items and choose to UNGROUP.
  16. Replies
    4
    Views
    85

    Re: Concatenate formula for dates

    =TEXT(K3,"mmm dd") & " - " & TEXT(L3,"mmm dd")
  17. Replies
    5
    Views
    88

    Re: Using Timeline Slicer

    ALL the values in the Date Initiated must be dates. Any Text values must be converted to dates.
    Don't forget to refresh the pivot cache after any manual cleaning.
    Get&Transform can do a better job...
  18. Replies
    3
    Views
    111

    Re: working with times and dates

    Well Date and Time is really a single value. Its just like any other number where Date is to the left of the decimal and Time is to the Right.

    Using Ahoy's mockup,
    =A+B-TIMEVALUE("3:05")
    Format...
  19. Re: Excel table: mysterious change of formulae

    Yes the sorting. You have a mix of fixed and relative referencing in your formula. A Table with such formulas is not meant to be resorted, especially when those references are within the table's...
  20. Replies
    12
    Views
    352

    Re: Filtering Missing Data

    Formatting does not change the values from numbers to text.
    You need to use Data\Text to Columns...
  21. Replies
    12
    Views
    352

    Re: Filtering Missing Data

    Sorting level limits, which was an assumption since we have no idea of how many combinations are in the original data set.
  22. Replies
    12
    Views
    352

    Re: Filtering Missing Data

    Switch to the 64-bit version.
  23. Re: Displayed date difference starts counting from one day again whenever a date difference exceeds one month

    =TEXT(INT(A1-B1),"0")&" Days "&TEXT(MOD(A1-B1,1),"H")&" Hours "&TEXT(MOD(A1-B1,1),"m")&" Minutes"

    This is not a value but a text result
  24. Replies
    3
    Views
    91

    Re: Help me Excel Community

    Your data needs to be known....
    But COUNT is one of the simple calculation options.
  25. Re: Need help grouping Categories and Sub-Categories

    Not mentioned, since you're new to Pivot Tables, is formatting the values items. If you right click on a value in the Pivot Table, you want to choose the NUMBER FORMAT to set the formatting of the...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4