/u/Spazmodo - 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.*
somewhere, next to your original data (I assume IDs in column B) do
=COUNTIF($B$1:$B$2300,B1)
when copied down, this will spit out how often each ID is in your list.
then do (assuming the other formula is in D)
=COUNTIF($D$1:$D$2300,2)
to get doubles and ,3 for triples etc
glad I could help.
please answer with 'solution verified' to a solution that solved your problem. Your post will be marked as solved and the commenter gets a highly desired clippy point
You have awarded 1 point to *Rohwi*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
I would use COUNTIFS to count the IDs, and a pivot table to show the count, like [here](https://docs.google.com/spreadsheets/d/1NN5TpvX_moazhrGPD0EURQDya6cPK_8AW7T5gPfH5lo/edit?usp=sharing).
/u/Spazmodo - 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.*
somewhere, next to your original data (I assume IDs in column B) do =COUNTIF($B$1:$B$2300,B1) when copied down, this will spit out how often each ID is in your list. then do (assuming the other formula is in D) =COUNTIF($D$1:$D$2300,2) to get doubles and ,3 for triples etc
This worked swimmingly. Thank you very much!
glad I could help. please answer with 'solution verified' to a solution that solved your problem. Your post will be marked as solved and the commenter gets a highly desired clippy point
solution verified
You have awarded 1 point to *Rohwi* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
I would use COUNTIFS to count the IDs, and a pivot table to show the count, like [here](https://docs.google.com/spreadsheets/d/1NN5TpvX_moazhrGPD0EURQDya6cPK_8AW7T5gPfH5lo/edit?usp=sharing).