Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 12th 05, 12:11 AM
TC
 
Posts: n/a
Default "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du

Excel 2003/ Is there a way I can use the "Criteria Range" in the
"Data/Filter/Advanced Filter" tool to select duplicates in a multi-column,
many-line spreadsheet by selecting based on only certain columns of
information. ie: columns including, Name, Address, City, State etc, as well
as columns containing data such as phone numbers which make all records
unique.

  #2   Report Post  
Old May 12th 05, 02:06 AM
Jason Morin
 
Posts: n/a
Default

TC-

Let's assume that your target columns are A, B, C, D and F. Place this in an
open cell (say J13):

=SUMPRODUCT(--(A2&B2&C2&D2&F2=$A$2:$A$500&$B$2:$B$500&$C$2:$C$50 0&$D$2:$D$500&$F$2:$F$500))1

And use $J$12:$J$13 as your criteria range, ensuring that *J12* is empty.

HTH
Jason
Atlanta, GA


"TC" wrote:

Excel 2003/ Is there a way I can use the "Criteria Range" in the
"Data/Filter/Advanced Filter" tool to select duplicates in a multi-column,
many-line spreadsheet by selecting based on only certain columns of
information. ie: columns including, Name, Address, City, State etc, as well
as columns containing data such as phone numbers which make all records
unique.



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
How do I count data in range A:A that is dependent upon criteria . h2ocats Excel Worksheet Functions 1 February 21st 05 01:55 PM
Function that filters a list (Database) for criteria in a range a. FirstVette52 Excel Worksheet Functions 0 February 8th 05 05:37 PM
use a date range as criteria in a countif formula mbparks Excel Worksheet Functions 3 January 3rd 05 12:06 AM
Specify a null value in an Excel Database criteria range Johnnyy2k Excel Worksheet Functions 2 December 28th 04 05:43 PM
can I use a range of dates as a criteria when using sumif? [email protected] Excel Worksheet Functions 5 December 2nd 04 02:37 PM


All times are GMT +1. The time now is 06:36 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017