03/07/2018

  1. L

    Dynamic lookups and counts

    Hi All, This has me stuck! I need a formula that will count the number of a certain value ("P") based on a value (the Item) in the same row and between a set of dates. A version of my data is below. I will have a second table with each Item, and next to it the count of Ps (or another value)...
  2. W

    Pivot Table Help with a Calculated Field...

    Thought I'd repost this as the formatting did not come through correctly in the original post...apologies. One thing I did try was to use MAX and MIN on the date fields to determine number of shifts being looked at and therefore get an accurate value: =DAYS360(MIN(C3:C17),MAX(C3:C17)) It...
  3. W

    Pivot Table Help

    I have a spreadsheet that calculates the time a surgical case takes on a particular shift (Thanks shg!). I am attempting to create a Pivot table that could analyze how much of the available room time is taken in a particular room or group of rooms during a given time period I inserted a...

Some videos you may like

This Week's Hot Topics

Top