LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default crossreferencing duplicate entries

Hi,

Haven't used Excel much, so I'm trying to find out how to do something that
I imagine is very simple.

I have a list of addresses and I want to filter it so I get only entries
that have two categories that exactly match another entry (for instance last
name and zip code) so that I can delete duplicate addresses.

Any ideas how I would go about doing something like this? Any help would be
appreciated. Thanks!

-Zach
 
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
Duplicate entries Radiorick Excel Worksheet Functions 5 March 23rd 19 11:39 AM
Duplicate entries Brenda Excel Discussion (Misc queries) 2 February 16th 07 06:17 PM
Crossreferencing values between 2 spreadsheets wolfsburg2 Excel Worksheet Functions 9 December 23rd 05 09:41 PM
Duplicate Entries ConfusedNHouston Excel Discussion (Misc queries) 1 November 1st 05 12:50 PM
Duplicate entries DMC Excel Worksheet Functions 1 December 19th 04 07:45 PM


All times are GMT +1. The time now is 03:14 PM.

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

About Us

"It's about Microsoft Excel"