|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 24th, 2005, 12:09 AM
|
|||
|
|||
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
March 24th, 2005, 12:11 AM
|
|||
|
|||
|
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
March 24th, 2005, 12:23 AM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| offset and indirect function | RICHARD ANNOR | Worksheet Functions | 1 | March 11th, 2005 03:09 AM |
| I'm offset by the Offset Function | Hari | General Discussion | 4 | August 17th, 2004 05:48 PM |
| OFFSET cell references | Gary Thomson | Worksheet Functions | 3 | February 13th, 2004 05:10 PM |
| INDIRECT formula question | wardcanoe | Worksheet Functions | 2 | December 30th, 2003 10:31 PM |
Linear Mode
