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

Page 1 of 6 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies

    Re: Top 10% Salaries

    I would have two Pivot Tables, one for each question.
    Filter by the desired Top 10 (Bottom 10) which is more flexible than its name suggest.
  2. Replies

    Re: VBA auto email

    Check Ron Debruin for some email code.
    However, your flow of the process will have the email sent before any comment is entered. Be careful as to what and when the email will be created by the...
  3. Re: Excel large sheet: Want to bring right side coloumns visible when needed

    Your premise would require either Freeze Panes or Split just for starters.... or you have to write VBA for each and every case you want to display where you would Hide the columns you do not want to...
  4. Re: Calculating Hours Worked and breaks taken

    It is likely that to meet record keeping standards for break-times, you should be clocking/recording those break times instead of the calculation you are attempting.
    Deducting a break time that an...
  5. Replies

    Re: Looking to make custom Ribbon buttons

    You can add any existing buttons or commands to a custom Ribbon or any Macros to a Ribbon as Buttons.
    You can also set what is the primary Ribbon by changing the order the ribbons appear.
    You are...
  6. Re: Save same sheet to PDF multiple times - is it possible?

    You are constrained by the capabilities of Excel (and the Microsoft VBA.) Neither the MS Export to PDF nor the Print to PDF function in Excel has the ability to Append the file.
    You are better off I...
  7. Re: Distinct Count based on given criteria

    Your Counting the uniques. And then SUMing the uniques. That seems redundant. But the redundancy doesn't show itself because the ARRAY part is evaluated before the SUM function is evoked, so it is...
  8. Re: Pivot Table Error: Can Count but not Sum

    There is at least one occurrence of non-numeric data.
  9. Re: Distinct Count based on given criteria

    Why SUM?
    Use COUNTIFS instead of COUNTIF
  10. Replies

    Re: Finding Difference Between Two Times

    For the Format of the total time, is the formatting
    [h]:mm:ss ?
  11. Re: VBA Help creating a .txt file - Issue with 0's and decimals

    You would need to have all values set as text before outputting to the TXT file.
    However, you might end up with an issue of quotation marks in the file.
  12. Re: Creating a Compound Table for a Variable Term


  13. Replies

    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
  14. Replies

    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...
  15. 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...
  16. 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.
  17. Replies

    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...
  18. 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"
  19. Replies

    Re: 10% Time Improvements

    Decimal time...??

    Format as "H:MM:SS" or "MM:SS"

  20. 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.
  21. Replies

    Re: change column headings to inches

    You need to in Page Layout View
  22. Replies

    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...
  23. Replies

    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...
  24. Replies

    Re: File size issue

    Merch Number. How many characters in this number?
  25. Replies

    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...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4