Find most frequently occurring string over multiple sheets

[nataliejb]

Hi All,

I am new to the Forums but regularly search old threads for helpful hints. Always manage to find something I can adaptto what I need. Legends!

I have an Excel file that contains 8 sheets (FY08, FY09....FY15). What I wouldlike to do is find the most frequently occurring name from all the sheets. Ihave used

=INDEX('FY08'!A3:A498,MODE(IF('FY08'!A3:A498<>0,MATCH('FY08'!A3:A498,'FY08'!A3:A498,0))))

to find the most frequently occurring name in each sheet but now I would liketo find the most frequently occurring name over all the sheets - which is not necessarilyone of the names that occurs most frequently in a single sheet.<o></o>
Previous threads I have come across are only to find howfrequently a particular name occurs in multiple sheets. This isn’t exactly what I am after as I don’twant to count the number of times a name appears but extract the most frequently occurring name.

I have tried to be fairly succinct with my issue but pleaselet me know if I haven’t explained it very well.<o></o>

Thanks for the help in advance!

Natalie.

 

[hiker95]

nataliejb,

Thanks for the feedback, and, kudos.

You are very welcome. Glad I could help.

And, come back anytime.