Hi,

In 2007 choose the command Data, Remove Duplicates

In 2003 enter this formula in G1

=IF(SUMPRODUCT(--(B2=B$1:B2),--(C2=C$1:C2),--(D2=D$1:D2),--(E2=E$1:E2),--(F2=F$1:F2))1,TRUE,0)

and copy it down as far as your data. Then highlight this column and press
F5, Special, Formulas, and uncheck all except Logicals, click OK. Press
Ctrl+- (control minus) and respond Entire Row.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"PointerMan" wrote:

I have a large spreadsheet that I need to clean up. My data is kept by row,
so some rows have the same information in two adjacent cells. An example is
below in rows 2 through 5.

1 DB A HF SR SCR PI
2 SAW DB SR DR DB DB
3 SAW DB SR DR DB DB
4 SAW DB SR DR DB DB
5 SAW DB SR DR DB DB

Is there a function that can automatically delete the 2nd duplicate cell
contents? I can delete them manually one at a time, but I'd like
to be able to clean up the entire sheet at once.