Count duplicates in a range ignoring blanks

**bjnockle** · 01-13-2021, 10:56 PM

Looking for formula to count duplicates in a column A2:A51 ignoring blanks. Formula to look through column A2:A51, ignore blanks and return duplicate counts. Desired outcome in B2. See attached sample file.

Thanks.

**bebo021999** · 01-13-2021, 11:22 PM

Try:

Please Login or Register  to view this content.

**bjnockle** · 01-13-2021, 11:48 PM

bebo021999: Outstanding solution. Thanks a lot.

**bebo021999** · 01-14-2021, 12:37 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Count duplicates in a range ignoring blanks

LinkBack

Thread Tools

Rate This Thread

Display

Count duplicates in a range ignoring blanks

Re: Count duplicates in a range ignoring blanks

Re: Count duplicates in a range ignoring blanks

Re: Count duplicates in a range ignoring blanks

Thread Information

Users Browsing this Thread

Similar Threads

Copy Columns A to F into H, ignoring any duplicates or blanks.

[SOLVED] SUMIF, ignoring blanks and find earliest date ignoring blanks

[SOLVED] Count or Sum Ignoring Specified Text & Blanks

Count number of cells with numbers ignoring both #n/a and blanks

Count unique values/text within a range of cells that contain duplicates, blanks & errors

Dynamic named range, ignoring duplicates and blanks, WITHOUT VBA

[SOLVED] Count Duplicates in a range - skip blanks

Bookmarks

Bookmarks

Posting Permissions