Array constants can only contain text in double quotes, plain numbers (no currency symbols or percent signs), or Boolean ...

E xcel has this useful feature that probably most people completely overlook—the Quick Analysis menu. If you've been manually creating charts, writing formulas for totals, or sp ...