nevermind - got it
"Wazooli" wrote:
Oops - make that skip every 8th column.
"Wazooli" wrote:
How do I get the following formula:
=IF(ROW()=VLOOKUP($A2,$AY$1:$BC$49,3,FALSE),MEDIAN (INDIRECT(VLOOKUP($A2,$AY$1:$BC$49,4,FALSE) & ":" & (VLOOKUP($A2,$AY$1:$BC$49,5,FALSE)))),"")
to skip every 8th row. I am unsure as to how INDIRECT,OFFSET and ADDRESS
interact with each other. The formula above works for the first column, but
fails for every subsequent 8th column.
wazooli
|