Is it possible or impossible to auto adjust range in a formula?
 

I have small ranges separated by blank rows, and have unique identifiers for
each range. Is it possible to have a range adjust on the criteria of blank
rows separating data or on the unique identifier cell? May be impossible but
how would I know if I dont know better. Thanks for you help. Below is a
formula for an example, I need to range $N$287:$N$297 and $I$287:$I$297 to
adjust.

Regards,

Vadda

=IF(COUNTIF($N$287:$N$297,N287)<2,"",$I$287:$I$297 )