wrote...
I need to pull the most commonly used word out of a data range. In
essence if I have a list of names; Is there any way Excel can pull up
the name that is repeated the most, and how many times it is repeated?
Essentially a mode of text.

I think Leo Heuser came up with this.

=INDEX(rng,MODE(MATCH(rng,rng,0)))