I am out of ideas. OP is trying to summarize LARGE and SMALL values across multiple sheets.
In spite of merged cells this part is working.
=LARGE('Season 1:Season 3'!$AF$2:$AH$11,ROWS($1:1))
This is not.
=SMALL('Season 1:Season 3'!$AF$2:$AH$11,ROWS($1:1))
My every attempt to coerce blank cells to FALSE fails. I've tried INDIRECT references to the sheets and only values from the first sheet return.
I'm missing something obvious I'm sure.
Anyone have some ideas?
Edit Left out the link. Sorry.
http://www.excelforum.com/excel-form...e-columns.html
Bookmarks