I have a user with an Excel spreadsheet who wants to use the mode function but it returns #N/A. I have tried it and I get #N/A, I am not sure if it he can use mode in this way? He also claims that he knows someone that says it works in Excel 2010 but I don't have it to test.
Here is what he is trying to do.
Any help would be appreciated