Rank/Large Help
Should B1 contain the value that appears most frequently in column A or the
largest value in column A??
--
Gary''s Student - gsnu200753
"Sandy" wrote:
Hello
I have a list of randomly repeating values in A1:A100. I would like a
formula in B1:B10 that will return the top 10 used entries in the list in
order of use highest to lowest. It is possible that there may be less than
10 used entries and in that case I would like a 0.
Thanks!
|