| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
INDIRECT, OFFSET et. al.
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| offset and indirect function | Excel Worksheet Functions | |||
| offset and indirect function | Excel Worksheet Functions | |||
| is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) | |||
| Offset and Indirect functions | Excel Discussion (Misc queries) | |||
| Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions | |||
Linear Mode
