Macro for counting duplicates in raw
Solved/Closed
smstha
Posts
2
Registration date
Monday 7 June 2010
Status
Member
Last seen
8 June 2010
-
7 Jun 2010 à 02:21
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 30 Nov 2011 à 17:36
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 30 Nov 2011 à 17:36
Related:
- Macro for counting duplicates in raw
- Delete duplicates in excel - Guide
- Will itunes import duplicates - Guide
- Dxo pure raw download - Download - Image editing
- Blackmagic raw speed test - Download - Diagnosis and monitoring
- Counting names in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
7 Jun 2010 à 05:39
7 Jun 2010 à 05:39
You are pretty close to what you want. You can do this
1. Select the column (lets says its A)
2. Go to filter, choose advance filter
2a. select copy to new location
2b. Ensure that "List range" is correct
2c. choose Unique value
2d. for have it B1 (for example)
This will give you in column B, a listing of unique names present in column A
Now that you have your unique names, it is time for having a count. For that you use a count IF
=COUNTIF(A:A, "=" & B2)
You can use excel macro recorder which with give you a macro of these steps
1. Select the column (lets says its A)
2. Go to filter, choose advance filter
2a. select copy to new location
2b. Ensure that "List range" is correct
2c. choose Unique value
2d. for have it B1 (for example)
This will give you in column B, a listing of unique names present in column A
Now that you have your unique names, it is time for having a count. For that you use a count IF
=COUNTIF(A:A, "=" & B2)
You can use excel macro recorder which with give you a macro of these steps
8 Jun 2010 à 05:45
smstha
chennai
17 Nov 2011 à 05:48
Thanks a lot for the answer. Is there a way to use a formula to get the uniques instead of advanced filter or pivot table so that it gets generated automatically instead of the extra step?
30 Nov 2011 à 17:36
I am not too sure about formula. Even if it can be done via formula it would need to be an array formula and formula makes excel respond slowly as thing get changed.