LIST OF PERSON'S NAMES

[MrPresident]

I have 7 worksheets in my workbook, one for each month 'January' thru 'June';
then a Summary worksheet to summarize the 6 preceding worksheets. In each of
the monthly worksheets there is an employee name listed in cell L5. The
employee name varies per month, sometimes it can be the same employee for
three months, then a different employee the other three months, etc.

What I'd like to do on my Summary worksheet, in cell L5, is to indicate the
employee name listed most frequently in the 6 monthly worksheets. The first
question folks sometimes ask is, "What if there's a different employee name
in each monthly worksheet?". That's not a factor because there will always
be an employee that will be listed in at least 2 monthly worksheets.

Would this be accomplished somehow with the INDEX function in the Summary
worksheet, cell L5?

 

[Steven]

I have had to do something similar and I approached it a different way. In
one sheet I have columns A through F :
Year / Month / Date / EmplNumber / EmplName / Category / Amount

The year and month are formulas: =Year(TheDateColumn) and
=Month(TheDateColumn) so I make sure I have the proper Year / Month with the
Date.

Using this method you just keep going down the page vs a diff page for each
month.

Then I do a pivot table and use count to identify number of occurances. And
with the pivot table you can do many things to tighten the query of results
you are looking for. I think this is a more prefered method becuase it gives
you more control of the data.

Hope this helps.