Spreadsheet: 95922d1295447808-lookup-and-count-strings-of-same-cells-example
Sheet: example of data

 | Employee [NAME] project RBU
 | Type of absence | 1day |  | 1/2 day
 | Annual Leave | A/L |  | AL 1/2
 | Stat days | ST |  | ST
 | Sickness | SICK |  | S 1/2
 | Leave (unpaid) | L/U |  | LU 1/2
 | Lateness | L |  | L 1/2
 | Left early | E |  | E 1/2
 | Paid special leave | PSL |  | PSL 1/2
 | No call no show | NCS |  | NCS1/2
 | Day off | DO |  | DO
 | Work | W |  | W
2010-01-01 00:00:00 |  | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total in days |  |  |  |  |  |  |  |  | Sickness |  |  | No call no show
Oracle ID | Day & date of month | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | Total A/L | Total Stat | Total Sickness | Paid special L | No Call No show | Leave (unpaid) | Total Absence |  |  | days of sickness in month which belong to 365 day count for occasions and sick days number | occasions |  | Days of No call no show | Occasions
 |  | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2010-01-15 00:00:00 | 2010-01-16 00:00:00 | 2010-01-17 00:00:00 | 2010-01-18 00:00:00 | 2010-01-19 00:00:00 | 2010-01-20 00:00:00 | 2010-01-21 00:00:00 | 2010-01-22 00:00:00 | 2010-01-23 00:00:00 | 2010-01-24 00:00:00 | 2010-01-25 00:00:00 | 2010-01-26 00:00:00 | 2010-01-27 00:00:00 | 2010-01-28 00:00:00 | 2010-01-29 00:00:00 | 2010-01-30 00:00:00 | 2010-01-31 00:00:00
 | Anna | SICK | S 1/2 | DO | NCS | NCS1/2 | W | W | SICK | DO | DO | SICK | S 1/2 |  | W | DO | DO | A/L | S 1/2 | W | SICK | W | NCS | DO | W | W | W | SICK | W | DO | DO | W | 1 | 0 | 6.5 |  |  | 0 | 7.5 |  |  | 2 |  |  | 1
 | Beta |  |  |  | LU 1/2 | L |  | SICK | DO | DO | SICK |  |  |  |  |  |  |  | SICK |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 |  |  | 0.5 | 3.5 |  |  | 0 |  |  | 0
 | Cecilia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SICK |  |  | SICK |  |  |  | SICK |  |  | 0 | 0 | 3 |  |  | 0 | 3 |  |  | 3 |  |  | 0
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 0 |  |  | 0
 | Eva |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 0 |  |  | 0
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 0 |  |  | 0
 | Gustav |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 0 |  |  | 0
 | Hugo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 0 |  |  | 0
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 0 |  |  | 0
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 | 0 |  |  | 0 |  |  | 0
Total occasion in absence |  | 1 | 0.5 | 0 | 0.5 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0.5 | 0 | 0 | 0 | 0 | 1 | 1.5 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 12.5 | 0 | 0 | 0.5 | 14 |  |  | 5 |  |  | 1