Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Trying to count the number of times a name appears / table
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Jacob Skaria, post: 3830890"] You can try the below.. 1. Select the range in Col A (companies) including the header. 2. Data>Filter>Advanced Filter>Copy to another location 3. In copy to I have selected D1 and check 'Unique records only' 4. Click OK will give you the unique list of companies. 5. In E2 apply the below formula =COUNTIF(a:a,d2) and copy that down as required Copy that to J2 and K2 Drag down as required. If this post helps click Yes [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Trying to count the number of times a name appears / table
Top
