You could use a helper column to do a counta of all the active cells in each
row, and then sort and delete all rows that have only two cells
occupied........

Vaya con Dios,
Chuck, CABGx3




"Roger Bell" wrote:

I have inherited a spreadsheet which has lots of duplicated rows. However,
some information is missing for certain fields. For example one row will
list:
Firstname (Jim), Lastname (Jones), Phone (1213111) and the duplicate will
just have say the Firstname (Jim) & Lastname (Jones).

What I would like to do is remove the second record from the spread sheet.
There are many instances of this throughout.
Is there a way that this can be achieved?

Thanks for any help