Please does anyone know a formula I can enter into a cell that will check the
11 cells immediately above it (which all have a text entry, i.e., a name, and
it will be just one word, not mutliple words) to see if any name appears in
more than 2 of the cells? I also need to be able to copy the formula to
lots of other cells in the same worksheet. By the way, the 11 cells that
need to be checked have an empty cell immediately above the 11 cells.

I hope you can understand what I'm looking for here.

If you can help, I'd really appreciate it.

Thanks, John C