Forum Discussion
Solved
Calculating MODE Across Several Worksheets
Hello. I have data in 11 different cells across several worksheets. For example, I have 20 worksheets in a single workbook and those worksheets all have data in cells D3, D5, D7, D9, D11, D13, D15,...
=MODE(TOCOL(Sheet1:Sheet20!D3))where Sheet1 and Sheet20 are the leftmost and rightmost of the 20 worksheets respectively.
Regards
Thanks to all of you! The "TOCOL" function is new to me - this is very handy. JosWoolley's resolution is more at my level of expertise and works great. Thank-you! There is one question I do have for JosWooley and I will reply to that post directly. Thanks again everyone!