Spreadsheet: 455482d1460372782-applying-an-if-formula-in-regards-to-multiple-columns-for-excel-forum
Sheet: Sheet 2

 |  | 2016
 |  |  | 1st Visit |  |  |  |  | 2nd Visit |  |  |  |  | 3rd Visit |  |  |  |  | 4th Visit |  |  |  |  | 5th Visit |  |  |  |  | 6th Visit |  |  |  |  | 7th Visit |  |  |  |  | 8th Visit
 | FG | Ship | Visit | Date | Inspector | Supt/SM | Visit Type | Visit | Date | Inspector | Supt/SM | Visit Type | Visit | Date | Inspector | Supt/SM | Visit Type | Visit | Date | Inspector | Supt/SM | Visit Type | Visit | Date | Inspector | Supt/SM | Visit Type | Visit | Date | Inspector | Supt/SM | Visit Type | Visit | Date | Inspector | Supt/SM | Visit Type | Visit | Date | Inspector | Supt/SM | Visit Type
 | 1 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 1 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 1 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 1 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 2 |  | Y | 2016-02-16 00:00:00 | GK | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 2 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 2 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 2 |  | Y | 2016-03-11 00:00:00 | BH | SM | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 2 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 2 |  | Y | 2016-02-16 00:00:00 | TM | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 3 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 3 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 3 |  | Y | 2016-01-27 00:00:00 |  | SM | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 3 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 3 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 3 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 3 | Sample For Conditions in G for End Result | Y | 2016-04-07 00:00:00 | KQ | Senior Management | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 3 |  | Y | 2016-03-06 00:00:00 | SGA | Supt | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 3 |  | Y | 2016-03-26 00:00:00 | SGA | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 3 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 4 |  | Y | 2016-02-24 00:00:00 | LJ | Supt | Sailing | Y | 2016-03-28 00:00:00 | RA | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 4 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 4 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 4 |  | Y | 2016-02-10 00:00:00 | RS | Supt | Sailing | Y | 2016-02-10 00:00:00 | RA | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 4 |  | Y | 2016-03-27 00:00:00 | RA | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 4 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 4 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 4 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 5 |  | Y | 2016-03-11 00:00:00 | DG | SM | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 5 |  | Y | 2016-01-21 00:00:00 | IW | Supt | Sailing | Y | 2016-03-08 00:00:00 | DG | SM | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 5 |  | N | 2016-02-08 00:00:00 | DG | SM | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 5 |  | Y | 2016-01-19 00:00:00 | IW | Supt | Non-Sailing | Y | 2016-03-09 00:00:00 | DG | SM | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 6 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 6 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 6 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 6 |  | Y | 2016-02-09 00:00:00 | JL | Supt | Non-Sailing | Y | 2016-03-13 00:00:00 | BM | SM | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 6 |  | Y | 2016-01-12 00:00:00 | BM | SM | Non-Sailing | Y | 2016-01-12 00:00:00 | AB | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 6 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 6 |  | Y | 2016-02-09 00:00:00 | AB | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 6 |  | Y | 2016-02-07 00:00:00 | AB | Supt | Non-Sailing | Y | 2016-02-12 00:00:00 | AB | Supt | Non-Sailing | Y | 2016-04-04 00:00:00 | AB | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 6 |  | Y | 2016-01-09 00:00:00 | AB | Supt | Sailing | Y | 2016-01-18 00:00:00 | AB | Supt | Non-Sailing | Y | 2016-04-05 00:00:00 | BA | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 7 |  | Y | 2016-02-28 00:00:00 | BP | Supt | Non-Sailing | Y | 2016-02-28 00:00:00 | GG | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 7 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 7 |  | Y | 2016-01-29 00:00:00 | BP | Supt | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 7 |  | Y | 2016-01-20 00:00:00 | GR | SM | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 7 |  | Y | 2016-03-03 00:00:00 | BP | Supt | Non-Sailing | Y | 2016-03-03 00:00:00 | GG | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 7 |  | Y | 2016-01-11 00:00:00 | BP | Supt | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 7 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 8 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 8 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 8 |  | Y | 2016-01-27 00:00:00 | SM | Supt | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 8 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 8 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 8 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 8 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 9 |  | Y | 2016-01-19 00:00:00 | TG | SM | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 9 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 9 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 9 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 9 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 9 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 9 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 9 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 10 |  | Y | 2016-03-01 00:00:00 | CK | Supt | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 10 |  | Y | 2016-01-12 00:00:00 | DG | SM | Sailing | Y | 2016-01-12 00:00:00 | NMi | Supt | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 10 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 10 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 10 |  | Y | 2016-03-15 00:00:00 | MH | SM | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 11 |  | Y | 2016-03-02 00:00:00 | MP | Supt | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 11 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 11 |  | Y | 2016-01-18 00:00:00 | NJ | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 11 |  | Y | 2016-02-16 00:00:00 | AS | SM | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 11 |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | 12 |  | Y | 2016-01-16 00:00:00 | KF | SM | Non-Sailing
 | 12 |  | y | 2016-01-06 00:00:00 | KF | SM | Non-Sailing | Y | 2016-03-11 00:00:00 | PD | Supt | Non-Sailing
 | 12 |  | N
 | 12 |  | N
 | 12 |  | N
 | 12 |  | N
 | 12 |  | N
 | 12 |  | N
 | 12 |  | N
 | 12 |  | N
 | H |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | H |  | Y | 2016-02-03 00:00:00 | BA | Supt | Sailing | Y | 2016-03-24 00:00:00 | BA | Supt | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | H |  | Y | 2016-02-03 00:00:00 | BA | Supt | Non-sailing | Y | 2016-03-20 00:00:00 | BA | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | S |  | N | 2016-01-25 00:00:00 | SW | Supt | Sailing | Y | 2016-03-24 00:00:00 | GC | Supt | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | S |  | Y | 2016-02-02 00:00:00 | SA | SM | Non-Sailing | Y | 2016-02-24 00:00:00 | GC | Supt | Non-Sailing | Y | 2016-04-06 00:00:00 | IBA | Supt | Non-Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | S |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | S |  | Y | 2016-03-12 00:00:00 | GC | Supt | Sailing | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 | S |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N |  |  |  |  | N
 |  | Total
 |  | Percentage