Spreadsheet: 269334d1381132589-array-formula-to-count-specific-text-ignoring-duplicates-jridge-021013
Sheet: Results

 |  | offen | = |  |  | Schulungsaufwand gesamt |  |  |  |  | Stunden
 |  | [NAME] | = |  |  |  |  |  |  |  | MT
 |  | erfolgt | =
MA Modul |  | Th. [NAME] | [NAME] | T.  Neumann | [NAME] | A. Brodemann | [NAME]. Sassen | R. Lemke | O.Scheffler | T.Oltmann | F.Rasper | L.Ulmer | S.Rehme | G.Haaken | N.Kügler | J.N.Hellmann | O.Kleine | M.Kuper | [NAME] | L.Loschen | D.Kusanke | [NAME] | H.Frese | U.Ruf | M.Bensch | M.Düssmann | P.Ritter | L.Wykhoff | [NAME] | [NAME] | P.Raschen | B.Gundlach
 | Bereich Dauer | GL | Prokurist |  |  | Lagerm. | Stellv. LM | Stellv. LM | Lager | Lager | Lager | Lager | Lager | Lager | Lager | Lager | Lager | Fahrer | Fahrer | Fahrer | Fahrer | Fahrer | Fahrer | Fahrer | Fahrer | Austellung | Lager | Lager | Theke | Einkauf | Lager | Verkauf | [NAME].T [NAME] | Teiln. ges. | Gruppen | [NAME]. | [NAME].
[NAME] | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS02 | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS03 | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS04 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS05 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS06 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS07 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS08 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS09 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS10 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS11 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS12 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS13 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS14 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS15 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS16 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS17 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS18 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS19 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS20 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS21 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS22 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS23 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS24 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS25 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS26 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS27 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TS28 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TM01 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TM02 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TM03 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TM04 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TM05 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TM06 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TM07 | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TM08 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TM09 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TM10 | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TM11 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
TM12 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | pLMA | Min | [NAME] | Ü/Nacht | Tage | expected
 | JöNi |  |  | JA+ |  | 6 |  |  |  | Have extended the date and table, when i now use a third group of dates it doesn't count the extra days.
 | ThKo |  |  | JA+ |  | 4 |  |  |  | Only used 2 date groups and works
 | [NAME] |  |  | JA+ |  | 6 |  |  |  | 3 date groups and doesn't count any extra
 | SoBe |  |  | JA |  | 3 |  |  |  | 3 date groups without Extra JA+ and works.
 | PePa |  |  | [NAME]
 | MaSc |  |  | [NAME]
 | ÖmTü |  |  | [NAME]
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  |  |  | R
 | GeKr |  |  | [NAME]
 | [NAME] |  |  | [NAME]
 | SeKo |  |  | [NAME]
 | MOD Datum | [NAME] | TS02 | TS03 | TS05 | TS05 | TS06 | TS07 | TS08 | TS09 | TS10 | TS11 | TS12 | TS13 | TS14 | TS15 | TS16 | TS17 | TS18 | TS19 | TS20 | TS21 | TS22 | TS23 | TS24 | TS25 | TS26 | TS27 | TS28 | TM01 | TM02 | TM03 | TM04 | TM05 | TM06 | TM07 | TM08 | TM09 | TM10 | TM11 | TM12
 | 2013-08-04 00:00:00
 |  |  |  |  |  | JöNi
 |  |  |  | ThKo | SoBe
 |  |  | [NAME]
 | 2013-08-05 00:00:00
 | 2013-08-06 00:00:00
 | 2013-08-07 00:00:00
 | 2013-08-08 00:00:00
 | 2013-08-12 00:00:00
 |  |  | [NAME]
 |  |  |  | ThKo | SoBe | JöNi
 | 2013-08-13 00:00:00
 | 2013-08-14 00:00:00
 | 2013-08-17 00:00:00
 |  |  |  |  |  | JöNi
 |  |  |  |  | SoBe
 | 2013-08-18 00:00:00
 |  |  | [NAME]
 | 2013-08-19 00:00:00
 | 2013-08-20 00:00:00