Help with dynamic ranges

  • Thread starter Thread starter JoAnn
  • Start date Start date
J

JoAnn

Can anyone recommend a good book/site/resource for creating and
troubleshooting dynamic ranges & using OFFSET()?

I need to get more general understanding of how they work with examples.
Mine seem to expand the range but don't carry over the formatting.

Thanks,
 
Mine seem to expand the range but don't carry over the formatting.

Formulas* cannot carry over formats.
They can only return values in the cells they are placed in.
*any kind, inclusive OFFSET, dynamic ranges etc

---
 
Ok, thanks.
--
JoAnn


Max said:
Formulas* cannot carry over formats.
They can only return values in the cells they are placed in.
*any kind, inclusive OFFSET, dynamic ranges etc

---
Click to expand...
 
Back
Top