With your data in A1 thru A10,

=INDEX(A1:A10,MODE(MATCH(A1:A10,A1:A10,0)))

will return Finance
--
Gary''s Student - gsnu200908


"Doug" wrote:

What would qualify as a name? Would it work if I take out the spaces?
--
Thank you!


"Gary''s Student" wrote:

Can't be used on text.
--
Gary''s Student - gsnu200908


"Doug" wrote:

I looked up the capability of the mode function and it said that the only
time it should return an #N/A value is when there are not two names, or
numbers in a range. I am not sure why but for the given stock market sectors,
the function below always returns a #N/A when it should return in this case
the name finance. Any suggestions?

ComputerandTechnology
BasicMaterials
Retail-Wholesale
Medical
Finance
Finance
IndustrialProducts
Utilities
Medical
Finance
=MODE(S832:S841)

--
Thank you!