Per Attached Sample Sheet, I need to find the most frequent number in each column B through AL and put the results in row 105 for each Column.
I tried “Index(ai5:ai104,MODE(match(ai5:ai104,ai5:ai104,0)))” but that did not work.
As always thanks for your help.
Bookmarks