Jym396
New member
Formula:
{=offset(ROUND(MAX(IF($D$8:$D$396=S1,$G$8:$G$396)),2)0,-4)}
Assuming the OFFSET arguments are:
[FONT="]=OFFSET (reference, rows, cols, [height], [width])
[/FONT]
{=offset(ROUND(MAX(IF($D$8:$D$396=S1,$G$8:$G$396)),2)0,-4)}
Assuming the OFFSET arguments are:
[FONT="]=OFFSET (reference, rows, cols, [height], [width])
[/FONT]
- reference - The starting point, supplied as a cell reference or range. My reference is the MAX IF
- rows - The number of rows to offset below the starting reference. Rows=0
- cols - The number of columns to offset to the right of the starting reference. Columns=-4
- height - [optional] The height in rows of the returned reference.
- width - [optional] The width in columns of the returned reference.