Hi Kim,
Since you were interested in two columns, you already have your
answer from Julie in
Duplicate And Unique Items In Lists
http://www.cpearson.com/excel/duplicat.htm
But when you are finished with that you might
also want to check out...
Excel terminology: you might take a look at another of Chip's
pages, because functions (formulas) can only return a value so
by themselves cannot eliminate anything.
Macros And Functions -- Macros as Opposed to Functions
http://www.cpearson.com/excel/differen.htm
Had you wanted to hide an entire row could use an Advanced Filter
utilizing a Worksheet Function to determine which rows would appear.
Of course you don't necessarily have to eliminate duplicates within
Excel. If you are obtaining your data from elsewhere such
as a database you might not include them in your Excel by
rejecting them before they get on the spreadsheet in the first place.
Within Excel you might prevent the creation of
duplicates by cell validation
Validate / Validation
http://www.mvps.org/dmcritchie/excel/validation.htm
with additional links for prevention, validation, filtering
