Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Re: VBA Code to Break a Comment into Multiple Lines

    During entry in a Cell, use ALT+ENTER to create the LF
    In a Comment Box use SHIFT+ENTER to create you LF.
  2. Replies
    1
    Views
    33

    Re: How can I highlight duplicate values

    Duplicate values or duplicate sets/rows of data?
  3. Replies
    1
    Views
    35

    Re: Database in Excel

    Details? More detail on the details...:confused:
  4. Replies
    3
    Views
    78

    Re: Piovt Table Sorting

    hmm. My suggestion was from macro-recording applying a Sort to a Data-Model-Pivot Table.
    That was the first thing I saw and expected it to cascade. I won't get a good chance to see again until...
  5. Re: Dynamic formula to calculate percentage

    The best way is a Pivot Table and provide the desired calculations at each desired Subtotal group. All the dynamics and formulas are taken care of by the Pivot Table. You only have to refresh the...
  6. Replies
    3
    Views
    78

    Re: Piovt Table Sorting

    try

    Dim pf as PivotFields
    (?)
  7. Replies
    1
    Views
    56

    Re: Copying Pivot Data to Table

    3. Probably. Since a Pivot Table usually summarises, you can LOAD the data using PowerQuery (now Get and Transform) and do your aggregate functions. Additionally, you can likely perform the...
  8. Re: Need expert advice with difficult formula

    If you have Dates, you can have a simply

    =Max(E12:E300)-MIN(E12:E300)
    & Format the cell as a custom format of

    "Average Yearly Payroll for "y" years and" m "months"

    The downside to this...
  9. Re: Need expert advice with difficult formula

    The values in D12:D300 are dates, amounts or other?

    Is there a column with the pay dates?
  10. Replies
    5
    Views
    67

    Re: Document Content to Body of Email

    If the content is static and just written up in a Word Document, it might be simpler to make that text an Auto Text or Quick Part.

    As far as the error in the loop, it appears it is trying to...
  11. Replies
    5
    Views
    67

    Re: Document Content to Body of Email

    Formatting in Outlook does have most the same elements as Word but not all.
    Why not Share the Word document by Email?
  12. Re: Pivot report not showing the date as per the source data format

    If the master data is a ranged source instead of a Table source, additional data may no be captured in the update. Could even be lost.
    Your data source for the Pivot Table should be a Table or from...
  13. Replies
    4
    Views
    66

    Re: Leading zero in CSV

    CSV is not truely a native Excel format. It is often set up as to be opened by Excel directly, but rarely should. Excel assumes the data import with the data type of General.
    Excel's "new" tool, Get...
  14. Re: Pivot Table Retained Items & Refresh All

    Ideally you don't use a Pivot Table as a LookUp table. You would likely be better bringing your data into PowerPivot and utilize the relationships there to give your Lookup solution.

    On the...
  15. Replies
    4
    Views
    66

    Re: Leading zero in CSV

    Leading zeros are not part of a value, but a formatting convention. To be able to retain the leading zeros, bring the value in as text.

    Just because a "Number" looks like a number and is referred...
  16. Re: Pivot report not showing the date as per the source data format

    It sounds like Excel has tried to be helpful and applied grouping to your date field.
    If so, Ungroup by Right+Clicking the field and choose Ungroup.
    You still may need to set the formatting...
  17. Replies
    1
    Views
    104

    Re: Combining Tables

    Using Get and Transform, you would Append the two tables. Add a column to indicate the Source/Region.
    You can Pivot the data to show distinct amounts by Region or combine the regions.
  18. Replies
    3
    Views
    100

    Re: Vlookup yet again

    Two other options.
    1. You can create a Pivot Table with the desired Table Columns in the Pivot Tables "Row" area. Use Tabular display, NO Subtotals and Repeat ALL Row labels.
    2. You can create a...
  19. Replies
    2
    Views
    66

    Re: Cannot open PivotTable source file

    Verify the path to the source file. Data/Connections.
  20. Re: Pivot table not recognizing formula values

    Because you have blanks, and your value "1" is a text string.

    =IF(ISTEXT([@[Date of Referral ]])=FALSE,0,1)
  21. Replies
    3
    Views
    60

    Re: Date Format in Excel

    Your sample Date/Time is good and does not demonstrate a problem.

    "...and put it in to a format that I am able to work with." How are you trying to work with the date/time serial number?
  22. Replies
    7
    Views
    245

    Re: get the 12th date

    Aug 12 is a Monday. It is not a Weekend. So you want Monday, August 12th?
  23. Replies
    1
    Views
    105

    Re: barcode and description

    Use Tables. Column B would utilize a VLOOKUP referencing a Table where you list the Inventory.
    Using Tables allows Excel to Fill down the formula as you add new rows. Reference a Table in a VLOOKUP...
  24. Replies
    7
    Views
    245

    Re: get the 12th date

    What is the policy?
  25. Replies
    7
    Views
    245

    Re: get the 12th date

    WORKDAY is the function to go with, or at least start with.
    Are you also excluding Mondays?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4