Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    646

    any tips for improving refresh speeds?

    Have a large file (157mb) with 50+ pivot tables and each pivot table is tied to powerpivot models (4 main data loads).... Each time I adjust a filter... I get "reading data..." for 30+ seconds......
  2. Re: abnormal power pivot error message 'string cannot be converted to date type'

    Additionally, getting 1/1/2018 and 41935 instead of 12/29/2015
  3. abnormal power pivot error message 'string cannot be converted to date type'

    Hi,

    NORMALLY when I get a date error with PowerPivot it is in relation to the type of cell and it gives me the header to look into. For instance, if the "contract date" had a blank or a non-date...
  4. Appended columns not updating in power pivot model

    Hi folks,

    My colleague sent over a workbook by in which a powerpivot model was created, I was tasked with adding a few data fields and refreshing for latest months data (so we need to appended...
  5. Re: headcount and spend by quarter, only spend by last 4 quarters and headcount by last 1 qtr

    http://s000.tinyupload.com/?file_id=77865353443689962574
  6. Re: headcount and spend by quarter, only spend by last 4 quarters and headcount by last 1 qtr

    my apologies, I thought since it was question of pivot charts and their functionality that the data would not be so ancillary. I'll put something together.
  7. headcount and spend by quarter, only spend by last 4 quarters and headcount by last 1 qtr

    Scenario is let's say we have customer in row, quarters in columns and spend / headcount in values.

    Is it possible to only show one quarter headcount while showing 4 quarter spend in the same...
  8. Finding unique values within subcategory using function

    Hi,

    I have a number of Unique ID's in a column, many of them are dups so I need the count of the # of unique value hits, which I can do using (assuming they are in column A)...
  9. Replies
    3
    Views
    317

    Re: two dates to match, one has timestamp

    Cheers!

    Could you explain why this works, I'd like to learn!
  10. Replies
    3
    Views
    317

    two dates to match, one has timestamp

    Hi,

    Have an easy one for you... Have two columns with dates, need a formula that will say if they match or not, only thing is that one column has a timestamp to the right of date (e.g. 11/20/2014...
Results 1 to 10 of 10