Thanks again Bob.But I don't know VBA or macros.If theres no other way don't
worry.I appreciate your help.

"Bob Bridges" wrote:

Ah, so "top 10 occurring numbers" doesn't mean the 10 greatest numbers, but
the numbers that occur most often? Got it.

Seems to me, though, that if you want to do it with Excel worksheet
functions you'll still have to include something in each workbook that counts
up...no, that's not going to work. (Pause for thought.) Ok, this may be
POSSIBLE to do with worksheet functions, but it's more complicated than I can
easily see right now. I think you need to make this a VBA program, a macro
in other words. Are you up for that?

--- "MAANI" wrote:
I think I need to make it more clear,I have 100 workbooks,in each
workbook there's one sheet,each sheet has numbers in column
H,with this format ####-##-###-####,I want a way to find the
10 most occuring numbers in column H for all workbooks.Example:
1234-56-789-1234 this is a number in column H,I want to know if
its one of the 10 most numbers repeating in column H in all
workbooks.

--- "MAANI" wrote:
I have like 100 workbooks,each one has column H with numbers
in this format ####-##-###-####,I want to find the top 10
numbers occuring in all these workbooks. Note that come cells
in column H are blanks.