Excel

Checking for Either of Two Text Values

Allen Wyatt's Excel tips -

Using a formula to find information in a text value is easy. Using a formula to find either of two text values within a larger text value is a bit harder. This tip examines different formulas you can use to figure out how many cells in a range contain either of two text values.

Read this ExcelTip: Checking for Either of Two Text Values
Microsoft Excel Tips - Learn Excel Faster!

Updating Automatically When Opening Under Macro Control

Allen Wyatt's Excel tips -

If your workbook contains links, you are normally given the opportunity to update those links when you open the workbook. When opening the workbook from within a macro, you probably don't want Excel to ask about updating the links. Here's how to stop Excel's normally inquisitive nature.

Read this ExcelTip: Updating Automatically When Opening Under Macro Control
Microsoft Excel Tips - Learn Excel Faster!

Stacked Column Chart with Stacked Trendlines

Jon Peltier -

Excel disables trendlines in stacked charts, but this tutorial shows two approaches to create a chart with stacked trendlines. The post Stacked Column Chart with Stacked Trendlines appeared first on...

continue reading...

Páginas

Subscribe to necesitomas.com agregador: Excel