Call in the Cavalry - 2015

@ quekbc

Sorry about that.

Here it is.

http://www.excelforum.com/excel-form...e-columns.html

Originally Posted by quekbc

Now, here's the funny thing. Try creating the formula by typing and selecting the cells using the mouse. I find that I cannot select Season 1 Season 2 and Season 3 sheets at the same time, i.e. it doesn't allow me to do 'Season 1:Season 3'. I don't know why that is the case. Here's the better part, when I create a copy of all the sheets unto a new workbook, it now works - and the SMALL function works too. Another Excel oddity perhaps.

I hadn't tried any of that and yes that is bizarre.

And thanks. I've passed that on.

@quekbc
Thanks for looking into that one.
Good find on the hidden sheets.