Delete Duplicate Rows if Multiple Columns are Identical

[meppwc]

Is there an easy way of deleting rows where the data in columns A, B and C are identical?
I would do this manually but there are thousands of rows.

 

[meppwc]

IMC3000	RICOH FINISHER SR3260 STAPLES	SUP-RIC-STAPLSR3260
IMC3000	RICOH FINISHER SR3260 STAPLES	SUP-RIC-STAPLSR3260
IMC3000	RICOH FINISHER SR3260 STAPLES	SUP-RIC-STAPLSR3260
IMC4500	RICOH FINISHER SR3260 STAPLES	SUP-RIC-STAPLSR3260
IMC4500	RICOH FINISHER SR3260 STAPLES	SUP-RIC-STAPLSR3260
IMC4500	RICOH FINISHER SR3260 STAPLES	SUP-RIC-STAPLSR3260

 

[meppwc]

Notice in the table above that there are duplicates for both the IMC3000 and IMC4500. I would need to remove a total of 4 rows and be left with 1 row for the IMC3000 and one row for the IMC4500. The table we are looking at is columns A, B and C.

 

[Fluff]

Have a look at the remove duplicates feature on the Data tab.

 

[meppwc]

Now I feel rather stupid. I should have thought there maybe the Remove Duplicate feature would compare multiple columns simultaneously. Thanks for pointing this out Fluff

 

[Fluff]

You're welcome & thanks for the feedback.