I have a list of raw data entries(names in a column).
Each column has approx. 240 entries.
This solution will be used 14 times(my datasheet has 14 columns).

I need to count how many times each name shows up, but variations of each name exist.
I cannot use countif because of entry variation.
How would you guys suggest I do this?

Please help!