Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 26th 09, 05:07 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
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?

  #2   Report Post  
Old January 26th 09, 06:23 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
Posts: 1
Default Delete records when certain records have duplicate column data


JVroom;199030 Wrote:
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?


Hi,
you will find 'here' (http://www.rondebruin.nl/delete.htm) exactly what
you need

HTH


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=54821



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare Rows and delete duplicate records Dizzlews Excel Worksheet Functions 3 August 12th 08 11:16 PM
Compare and delete duplicate records charles Excel Worksheet Functions 3 June 17th 08 11:46 AM
Delete Duplicate records Finger Tips Excel Worksheet Functions 2 April 29th 07 08:42 PM
how to delete duplicate records in a row Christian Setting up and Configuration of Excel 2 July 21st 06 01:39 AM
automatically delete records w/duplicate address in excel PUSH Excel Discussion (Misc queries) 1 May 24th 05 12:48 PM


All times are GMT +1. The time now is 10:00 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017