Anyone who speaks Dutch can help with conditional formatting? http://www.excelforum.com/excel-prog...-datelist.html
Anyone who speaks Dutch can help with conditional formatting? http://www.excelforum.com/excel-prog...-datelist.html
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Could anybody see if these instructions to hyperlink to a word doc will work for them
http://www.excelforum.com/excel-form...ml#post4201180
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
Last edited by FlameRetired; 09-29-2015 at 01:10 AM.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks