one approach you could try. I assume you do not want empty/blank cells
considered?

=INDEX(A1:A10,MODE(IF(A1:A10<"",MATCH(A1:A10&"",A 1:A10&"",0))))

array entered using Ctrl+Shift+Enter. of course it will only find the first
one in case of a tie.

"Kim" wrote:

Hello guys, pls. help.

Column A
dog
cat
cat
dog
dog

I would like to know which animal in the column A is max. or is min.
the max. is dog.
the min. is cat.

What is the formula to use?