Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I count data in range A:A that is dependent upon criteria . | Excel Worksheet Functions | |||
Function that filters a list (Database) for criteria in a range a. | Excel Worksheet Functions | |||
use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
Specify a null value in an Excel Database criteria range | Excel Worksheet Functions | |||
can I use a range of dates as a criteria when using sumif? | Excel Worksheet Functions |