If statement missing segment

Hi

I have data which looks like;

1	Case	w	x	y	z	aa
2	Case 1	Reason 1	Reason 2	Reason 3		0
3	Case 1	Reason 1	Reason 2	Reason 3	Reason 4	1
4	Case 2	Reason 1				0
5	Case 2	Reason 1	Reason 2			0

In AA is the following code.

Please Login or Register  to view this content.

In AA5 I want to return 1 as the line relating to case 2 with the most information.

I know there is a section of code missing but I can't work out where.

Any help appreciated.

Assuming that the column header aa is in cell F1:
Paste the following into cell G2:

Formula:

Please Login or Register  to view this content.

Paste the following into cell F2:

Formula:

Please Login or Register  to view this content.

Select F2:G2 and drag the fill handle down to cell G5.
Let us know if you have any questions.