Hi,
I would like to search of repeating words in excel across multiple worksheets and display the results as sheet numbers and frequency table::
Eg:
Voltaire
Sheet 111
Freq: 3
Sheet 200
Freq: 6
Sheet 303
Freq: 1
Can somebody advise the formula for that?
Thanks
TJ