Macro for counting duplicates in raw
Solved/Closed
smstha
Posts
2
Registration date
Monday June 7, 2010
Status
Member
Last seen
June 8, 2010
-
Jun 7, 2010 at 02:21 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 30, 2011 at 05:36 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 30, 2011 at 05:36 PM
Related:
- Macro for counting duplicates in raw
- Spell number in excel without macro - Guide
- Macros in excel download - Download - Spreadsheets
- Blackmagic raw speed test download - Download - Diagnosis and monitoring
- Excel macro to create new sheet based on value in cells - Guide
- Automatically run a macro when opening a worksheet - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 7, 2010 at 05:39 AM
Jun 7, 2010 at 05:39 AM
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
Jun 8, 2010 at 05:45 AM
smstha
chennai
Nov 17, 2011 at 05:48 AM
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?
Nov 30, 2011 at 05:36 PM
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.