I am trying to use SMALL function to return 2nd largest value, but SMALL does not seem to like nested formulas ("There's a problem with this formula." message). Can anyone suggest how I can either adapt my formula or perhaps propose an alternative solution?
I want to do it without the use of helper columns/cells.
Essentially I want to return the count of the 2nd most frequent character (In some scenarios 2nd most frequent could be the same as MAX).
Contents in cell A1 is AAABBBBCC
Using below max formula I get the answer 4, as expected;
But when I try and adapt to SMALL it does not work;
I attach above in worksheet also. I am using Mac Excel incase that is relevant.
Bookmarks