12/31/2017

Sorry, I am sleepy: How do I combine two IF(AND formulas to get a desired result or leave blank if both formulas are FALSE The formula in B1 is =IF(AND($A1>=$E$1,$A1>=$F1),$F$2,"") The formula in C1 is =IF(AND($B1>=$E$2,$B1>=$F2),$F$3,"") I need a formula that can be combined with the...

Hello, I have a set of data points that I am trying to get a count on the number of times a start date is within the date range of other lines and it has the same ID (Pos). I'm guessing it would count its own line and I am looking to count other lines that fulfill the same criteria. Below is a...

I have a pivot table that is utilizing a field for row labels based off the following formula: TEXT(INT([@[DATE_TIME]]-WEEKDAY([@[DATE_TIME]])+1),"yyyy-mm-dd") This formula removes the time stamp from my date field. However, when trying to select certain dates from within the filter...

Hi! I have below a small portion of a file. I have sorted my file by 'PART_NUMBER'. But now I want to see if there is a formula to tell me if the part number in red has a different rate than the part number in black. I am trying to see which ones are equal to, less than or more than the white...