Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    4
    Views
    1,480

    Re: Communication methods

    You have a little evil streak, don't you? I think we will get along just fine. :diablo:
  2. Replies
    4
    Views
    1,480

    Communication methods

    Greetings Excellers!

    I'm currently working on a workbook with lots of UDFs and other volatile functions. Trust me, I've done my research and the UDF/volatile function mode is the preferred method...
  3. Replies
    4
    Views
    141

    Re: Listing month names in all caps

    Thanks to all for the great responses. I think I'm going to go with Rick's solution although I know the next person who is called to maintain it will be confused by the non-traditional cell...
  4. Replies
    4
    Views
    141

    Listing month names in all caps

    Hello Excellers! How can I make a cell values appear in all caps?

    I have the following formula in several cells: =DATE($U$1,COLUMN()-2,1). The cell is formatted to show just the month...
  5. Replies
    4
    Views
    1,162

    Re: Pivot table date formatting

    I never thought of duplicating the field. That shouldn't be too difficult to incorporate into the data.

    Thank you
  6. Replies
    4
    Views
    1,162

    Re: Pivot table date formatting

    Most of the time I group the dates, too, but in this instance, specific dates are important. I just thought it was odd that the date format changed and would not allow me to adjust the format.
  7. Replies
    4
    Views
    1,162

    Pivot table date formatting

    I have a workbook with several pivot tables created from the same pivot cache. The dates in the original data table are formatted as mm/dd/yyyy (11/30/2018). All of the pivot tables, however, show...
  8. chart formatting looks awful on new computer

    I just received a new computer at work and in switching from Excel 2010 to 2016 some of my workbooks haven't fared as well as others.

    In one workbook that I use daily, I have several stacked...
  9. Re: Speed up workbook with many SUMPRODUCT formulas

    Thanks for the help from ALL of you.

    I took advice from everyone who responded and here is what I came up with:
    Joe 4: You are correct a database solution would be better, but that is not...
  10. Speed up workbook with many SUMPRODUCT formulas

    Hello All!

    I have a massive workbook with thousands of records. For each record, I need to include three weighted averages. I am using SUMPRODUCT to calculate the weighted average. Every time a...
  11. Replies
    6
    Views
    720

    What should I buy?

    I've been tasked with a project that requires something more robust and secure than Excel macros. In the distant past, I wrote projects like this using Visual Basic. Since Visual Basic has gone the...
  12. Replies
    4
    Views
    438

    Re: pivot table missing field

    I changed the data range to a table and it's working fine now.

    Thank you for your time and help.
  13. Replies
    4
    Views
    438

    Re: pivot table missing field

    Success of a sort!

    You gave me an idea to use the normal row and column references rather than a dynamic named range for the data source and it updated properly. WooHoo!! Now I need to figure...
  14. Replies
    4
    Views
    438

    Re: pivot table missing field

    Wow! Thank you for responding so quickly.

    The columns are in order and visible. I've repeatedly changed the data source in the frantic hope that "This time it will work" but it never does.
  15. Replies
    4
    Views
    438

    pivot table missing field

    Please accept my apology in advance, this is going to be a long post.

    I have a large workbook which gets sent to our board of directors every month. The data is downloaded from our mainframe and...
  16. Replies
    7
    Views
    270

    Re: Eliminate pivot table message

    I thought about putting the stats above the pivot, but it created a disconnect between the data. The stats referred to the pivot column headings and putting the page filters in between was...
  17. Replies
    7
    Views
    270

    Re: Eliminate pivot table message

    I want the pivot table to update automatically. However, if the data area of the pivot table is going to expand where it will overwrite the statistics, it will give the message that I listed above. ...
  18. Replies
    7
    Views
    270

    Re: Eliminate pivot table message

    I was hoping to avoid using application.displayalerts = false in case the user had more than one file open. I guess there's no other way around it, though.
  19. Replies
    7
    Views
    270

    Eliminate pivot table message

    I have created a pivot table which displays the amount for cash drawers over a user-selected period of time. Below the pivot table, there are a few rows with statistics for each drawer. The...
  20. Replies
    3
    Views
    293

    Re: Pivot Table Conditional Formatting

    I believe "END AMT" will always be there, but things change. Your formula works great, though. I'm sure going forward, I'll be able to modify it according to whatever the end users request.
    ...
  21. Replies
    3
    Views
    293

    Pivot Table Conditional Formatting

    Hi all!

    I'm working on a project that keeps track of all the cash in a cash drawer. The end user would like all cash drawers with balances over $12000 highlighted. Supervisor drawers, which have...
  22. Re: Need array formulas to return names meeting criteria

    Yeah, I know that a formula is nasty and painful, but I'm trying to avoid VBA because of all the hassle I get from auditors. The end user let me know that this isn't a critical item, but I'm still...
  23. Re: Need array formulas to return names meeting criteria

    My bad--originally we wanted the condition to be >=3, but changed it at the last minute.

    You can substitute "or" for and/or if you like. I was just giving the option of using two formulas instead...
  24. Need array formulas to return names meeting criteria

    I have the following list:
    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col...
  25. Replies
    8
    Views
    1,245

    Re: Calculating Commission

    I never would have dreamt of using median for a formula like this. Genius!
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4