Test loop required

[LaDdIe]

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

 

[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