Let's assume the cell you want to put the formula in is A11, then put this
array-entered** formula in A11...

=MAX(COUNTIF(A1:A10,A1:A10))

**Commit this formula with Ctrl+Shift+Enter, not just Enter by itself.

Note that all I did is specify the range covering the 10 cells above the
cell the formula is placed in. You can copy this formula anywhere (lower
than Row 10) and it will always refer to the 10 cells above it.

--
Rick (MVP - Excel)


"John WEC" wrote in message
...
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