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 ...
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