• Hot Topics

Excel =mode(if(and help

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) So far I can get the below to work based only on using greater than 31/12/12 and not with the less than option as follows: {=MODE(IF([Jan12_May14_Closed_Cases.xlsx]report1401715985583!$A$2:$A$56366=J2,IF([Jan12_May14_Closed_Cases.xlsx]report1401715985583!$I$2:$I$56366,[jan12_may14_closed_cases.xlsx]report1401715985583!$m$2:$m$56366)))}>

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of June 9, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel

privacy policy