Hi,

I feel sure that there must be a way to do what I want but I can't see
how, not being an Excel expert.

I am using Excel 2003 and have a list of offers made to applicants for
housing. Many applicants have had more than one offer made, having
refused some. I am trying to display the common applicant details on
the first line of their offers only, only displaying offer details on
every line. See simplistic example.

Now:

App Name No of Offer Property Status
No Offers No
1 Mr Jones 3 1 1 High Street REFD
1 Mr Jones 3 2 2 Bank Street REFD
1 Mr Jones 3 3 9 Elm Row ACCT

What I would like but can't work out:

App Name No of Offer Property Status
No Offers No
1 Mr Jones 3 1 1 High Street REFD
2 2 Bank Street REFD
3 9 Elm Row ACCT

I know I could export the lot into Access for reporting but I really
would appreciate it if anyone could help me to do this in Excel without
the extra step.

Thanks.

Joan