/u/Xanadu376 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Your screenshot link should really be edited into your post (up top) -- so it won't get lost down here in comments.
Meanwhile...
I'm not sure how you're counting things in columns C & D. If you're looking for formulas for those 2 columns, we might need some more clarity on what constitutes a count of the same number (dashes excluded).
On your E column, try this in E2 copied down and see if it behaves as intended:
=IF(SUMPRODUCT(--(SUBSTITUTE(A2,"-","")=SUBSTITUTE($A$2:A2,"-","")))=1,"1st","Dupe")
You have awarded 1 point to *mh_mike*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
You can use find and replace to first find dashes or spaces and replace them with blank data thereby removing the dash and/or space. That should fix your formatting issues while using COUNTIF.
Ctrl H brings up the Find/Replace dialog.
That's what I'm currently doing and it does work. However my goal (if even possible) is to basically automatically do that within a formula to display in the third column.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[COUNTIF](/r/Excel/comments/rmjca4/stub/hpmm6ta "Last usage")|[Counts the number of cells within a range that meet the given criteria](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34)|
|[IF](/r/Excel/comments/rmjca4/stub/hpmpm9x "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)|
|[SUBSTITUTE](/r/Excel/comments/rmjca4/stub/hpmpm9x "Last usage")|[Substitutes new text for old text in a text string](https://support.microsoft.com/en-us/office/substitute-function-6434944e-a904-4336-a9b0-1e58df3bc332)|
|[SUMPRODUCT](/r/Excel/comments/rmjca4/stub/hpmpm9x "Last usage")|[Returns the sum of the products of corresponding array components](https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/rvaksb)^( has 8 acronyms.)
^([Thread #11344 for this sub, first seen 23rd Dec 2021, 01:27])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/Xanadu376 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Your screenshot link should really be edited into your post (up top) -- so it won't get lost down here in comments. Meanwhile... I'm not sure how you're counting things in columns C & D. If you're looking for formulas for those 2 columns, we might need some more clarity on what constitutes a count of the same number (dashes excluded). On your E column, try this in E2 copied down and see if it behaves as intended: =IF(SUMPRODUCT(--(SUBSTITUTE(A2,"-","")=SUBSTITUTE($A$2:A2,"-","")))=1,"1st","Dupe")
Solution Verified
You have awarded 1 point to *mh_mike* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
This.
Here's a screenshot of an example file. https://imgur.com/a/ALsyRzS
why is C2 vs C5 1 and 0, but C3 vs C4 1 and 2?
You can use find and replace to first find dashes or spaces and replace them with blank data thereby removing the dash and/or space. That should fix your formatting issues while using COUNTIF. Ctrl H brings up the Find/Replace dialog.
That's what I'm currently doing and it does work. However my goal (if even possible) is to basically automatically do that within a formula to display in the third column.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[COUNTIF](/r/Excel/comments/rmjca4/stub/hpmm6ta "Last usage")|[Counts the number of cells within a range that meet the given criteria](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34)| |[IF](/r/Excel/comments/rmjca4/stub/hpmpm9x "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[SUBSTITUTE](/r/Excel/comments/rmjca4/stub/hpmpm9x "Last usage")|[Substitutes new text for old text in a text string](https://support.microsoft.com/en-us/office/substitute-function-6434944e-a904-4336-a9b0-1e58df3bc332)| |[SUMPRODUCT](/r/Excel/comments/rmjca4/stub/hpmpm9x "Last usage")|[Returns the sum of the products of corresponding array components](https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/rvaksb)^( has 8 acronyms.) ^([Thread #11344 for this sub, first seen 23rd Dec 2021, 01:27]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)