dynamic range formula

Originally Posted by tigeravatar

of course not, the formula is looking in columns a:d with they key column being c where is counts the occurrences of "f". You have to tell the formula what columns to look in and provide it with the key column. You should be able to adapt the provided formula.

=offset($d$8, 0, 0, countif($f:$f, "f"), 2)


This isnt working..