If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
filtered list
If I have done an advanced filter from a Master db and
filtered a list of juveniles within a 3 month period, and in that list some of the juveniles are listed more than once, is there a formula that will count only one name and not all of the same names? I only want to get a total for that age group within the 3 months, but I don't want excel to count duplicates. Thanks, |
#2
|
|||
|
|||
filtered list
In the advance filter, data|filter|advanced filter, there
is an option for unique records only. Lance -----Original Message----- If I have done an advanced filter from a Master db and filtered a list of juveniles within a 3 month period, and in that list some of the juveniles are listed more than once, is there a formula that will count only one name and not all of the same names? I only want to get a total for that age group within the 3 months, but I don't want excel to count duplicates. Thanks, . |
Thread Tools | |
Display Modes | |
|
|