Hi,

I'm working on a spreadsheet to track sick absence.
I need a solution to provide the required results as below.
For simplicity;
I have a row of cells A1:J1
A1 & B2 = value €œSick€� if the next cell C3 does not = €œBTW€� then K1 =
€œPending€�,
However if A1, B1 & C1 = €œSick€� if the next cell D1 does not = €œBTW€� then K1
= €œPending€�,
If A1 = €œSick€� and B2 = €œBTW€� and C1 & D4 = €œSick€� if the next cell E1 does
not =€�BTW€� then K1 = €œpending€�.

Each occurance of Sick should be followed by a BTW otherwise K1 to show
pending,
If J1 = €œSick€� then the solution must look at Row 2 for BTW in which case
K2 will show €œpending€�.

I have faith (fingers x'ed)

Regards

LaDdIe

Hi,

(Originally posted with example error)

I'm working on a spreadsheet to track sick absence.
I need a solution to provide the required results as below.
For simplicity;
I have a row of cells A1:J1
A1 & B1 = value €œSick€� if the next cell C1 does not = €œBTW€� then K1 =
€œPending€�,
However if A1, B1 & C1 = €œSick€� if the next cell D1 does not = €œBTW€� then K1
= €œPending€�,
If A1 = €œSick€� and B1 = €œBTW€� and C1 & D1 = €œSick€� if the next cell E1 does
not =€�BTW€� then K1 = €œpending€�.

Each occurance of Sick should be followed by a BTW otherwise K1 to show
pending,
If J1 = €œSick€� then the solution must look at Row 2 for BTW in which case
K2 will show €œpending€�.

I have faith (fingers x'ed)

Regards

LaDdIe