Hello Frank,

Thanks again for all your help - much appreciated.

I entered in all your formalas and receieved the following Excel
warnings:

I inserted a Helper column in column E and entered the following formula
in E3 and copied down to the end of my list:

=IF(ISNA(MATCH(0,COUNTIF($E$3:$E3,$D$3:$D$1000),0) ),"",INDEX($D$3:$D$100
0,MATCH(0,COUNTIF($E$3:$E3,$D$3:$D$1000),0)))

Excel warned that it could not calculate the formula. Cell references
in the formula refer to the formulas results, creating a circular
reference.

I changed the Name Definition of SCA to:

SCA =Offset('SA Register'!$E$3,0,0,COUNTA('SA
Register'!$E$3:$E$65536)-COUNTBLANK('SA Register'!$E$3:$E$65536),1)

Excel warns that the source currently evaluates to an error.

Could you please help as I do not know how to fix this.

Kind regards,

Chris.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!