You can use ISERROR to test whether a value or the results of a formula are an error. It will return TRUE if it detects an ...
Find new ideas and classic advice on strategy, innovation and leadership, for global leaders from the world's best business and management experts.
MUO on MSN
I stopped consolidating sheets by hand because Excel’s INDIRECT function does all the work for me
With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback