-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
filters
- Thread starter ajmcrae
- Start date
Cbrine
Well-known Member
- Joined
- Dec 2, 2003
- Messages
- 3,196
ahmcrae,
You can't use the filters to ID the dup's, but you can use the advanced filter to eliminate the duplicates.
To Identify them, you will need to use the countif function.
=Countif(MyDataRange,CurrentAddress)
=Countif($A$1:$A$99,A1)
HTH
Cal
You can't use the filters to ID the dup's, but you can use the advanced filter to eliminate the duplicates.
To Identify them, you will need to use the countif function.
=Countif(MyDataRange,CurrentAddress)
=Countif($A$1:$A$99,A1)
HTH
Cal
Upvote
0
Similar threads
- Question
- Question
