How to receive an exact count from a list based upon unique upper/lower case characters

**kendallrawls** · 03-12-2014, 12:04 PM

Hello-

I am working sum up how many times a string of numbers and letters appear in a list of about 2,000 entries. My initial thought was to do a simple Countif function. However; my list contains strings such as:

90989ABC
90989abc

So when I do a countif function - I am receiving a result of "2" for both "90989ABC" and "90989abc" where in actuality I need to formula to return a result of 1 because they represent 2 different types of records.

As I mentioned, I have a list of about 2,000 entries that include a high number of duplicates - so I want to see how many times the entry is "A1" for example appears in the column A:A accounting for an exact match.

Thank you!

**XOR LX** · 03-12-2014, 12:13 PM

Hi and welcome to the forum!

Difficult to give you a definite answer since you don't attach a workbook and only give one example. Can I just ask: is case sensitivity the only issue preventing your COUNTIF solution from working?

Regards

**sktneer** · 03-12-2014, 12:16 PM

One way to do that is by using the following array formula. Remember to confirm it with Ctrl+Shift+Enter

=SUM(IF(EXACT(A:A,A1),1,0))

**kendallrawls** · 03-12-2014, 12:48 PM

The sumif worked! I knew it was something along those lines, just couldn't figure out the details. Thank you for your help!!!!!

**sktneer** · 03-12-2014, 12:50 PM

Glad to help you. Thanks for the feedback.

If that takes care of your question, please mark your thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

How to receive an exact count from a list based upon unique upper/lower case characters

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to receive an exact count from a list based upon unique upper/lower case characters

Re: How to receive an exact count from a list based upon unique upper/lower case character

Re: How to receive an exact count from a list based upon unique upper/lower case character

Re: How to receive an exact count from a list based upon unique upper/lower case character

Re: How to receive an exact count from a list based upon unique upper/lower case character

Thread Information

Users Browsing this Thread

Similar Threads

Add characters between lower case and upper case letters

[SOLVED] Excel 2007 : Change Cell color based on upper of lower case

Upper and Lower case in a Count

[SOLVED] Help w/ project. Counting upper and lower case characters in a cell.

[SOLVED] Count the occurance of upper or lower case letters

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions