There are 2 sheets with each 4 columns. Type: Startsession or Presentation Method: Method A, B or C Number: Unique identification number which can occur multiple times Region: Region can occur mu...
arnel_gp Not exactly. The result in sheet 3 should only count if a unique number has had both a presentation AND a startsession. So in my example 'Noord holland' and 'Overijssel' should return 1 and 'Zuid holland' should return 0, since the uniqe number only had a 'Presentation'.
