Deliminator question
I want to count the information but don't want duplicates how can I do this and add the correct info for an accurate count? AHA.10133|1 AHA.101361799|1 AHA.10205|1 AHA.1012178447|1 AHA.10135|1 AHA.10135|3 AHA.10138|7 AHA.103352686|1 AHA.103352686|1 AHA.103352686|1 AHA.10135|1 AHA.10135|3 AHA.10138|7 Want this to equal 1…