Didn't get far myself

You could identify the Company names with this forumla if all in upper
case by putting this in say C2

=IF(A1<"",EXACT(A1,UPPER(A1)))

Then Filter on the True's and add this forumlua to D2

=IF(AND(C1=TRUE,OFFSET(C1,1,0)=FALSE,OFFSET(C1,2,0 )=FALSE),"Two
lines","one Line")

Then in E2 enter

=COUNTIF($C$1:C1,"TRUE") to group the addresses e.g

Company Name 1
Address Line 1 1
Address Line 2 1
Company Name 2
Address Line 1 3
Company Name 3
Address Line 1 3

Then you could stick it in the pivot and only look at Uncomplete
addresses ??

Which should help

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562319