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

 |  | 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
 | 2013-08-04 00:00:00
 | 2013-08-05 00:00:00
 | 2013-08-29 00:00:00
 | pLMA | Min | [NAME] | Ü/Nacht | Tage | expecting
 | JöNi |  |  | JA+ |  | 5 |  | Because the dates have a gap inbetween so this user travelled there twice so 2 travel days
 | ThKo |  |  | JA+ |  | 4 |  | Because the dates have no gaps so this user only travelled once so 1 travel day
 | [NAME] |  |  | JA |  | 6? |  | Is this correct, then? [NAME] has four entries (added by me), though since three are on consecutive days, he only receives one extra travel day for that plus the one for the separate date.
 | SoBe |  |  | [NAME]
 | PePa |  |  | [NAME] |  |  | 1 | User could have multiple sets of dates so formula must look for groups of dates and add +1 for each group the user was there.
 | MaSc |  |  | [NAME] |  |  | 2 | Option JA astays as it is just number of days user was there.
 | ÖmTü |  |  | [NAME] |  |  | 3 | Option Nein stays the same as in 0 days are shown.
 | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME]
 | 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 |  |  |  | [NAME]
 |  |  | ThKo | JöNi | [NAME]
 |  | JöNi
 | 2013-08-05 00:00:00
 |  |  |  |  | [NAME]
 |  |  | ThKo | JöNi
 |  |  | JöNi | JöNi
 | 2013-08-06 00:00:00 |  |  |  | [NAME]
 |  |  | ThKo
 | 2013-08-29 00:00:00 |  |  |  |  |  |  | JöNi
 |  |  | ThKo | JöNi
 | 2013-08-30 00:00:00
 |  |  |  |  | [NAME]
 | 2013-09-01 00:00:00