View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JVroom JVroom is offline
external usenet poster
 
Posts: 1
Default Delete records when certain records have duplicate column data

Hi,

I'm new to excel.

I want to delete (sort of) duplicate records.

My spreadsheet has many columns.

My spreadsheet has many records

I want to delete records where the data in just a few columns is the same in
multiple records. (e.g. if the values in columns "A" "B" "D" "F" in any
record is duplicated in multiple rows ..delete all matching records/rows.

A= house number
B= street name
D=apt number
F=city

Bonus points: Can a macro/button be created that will allow me to load a
spreadsheet and then somehow run the above filter/function on the loaded
spreadsheet?