I am trying to calculate the mode of our turn-around times for cases we handle as follows: In column N, which contains whole numbers, which I want to obtain the mode values of, if:
- Column A equals the name of a person in my team reference by cell J2
- if the date in column I was greater than 31/12/12 (referenced J1) and less than 01/01/2013 (referenced by K1)
This question generated 20 answers. To proceed to the answers, click here.
This thread is current as of June 09, 2014.