Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
array formula questionPosted by Andonny on June 09, 2001 8:05 PM
I would like to know how I am able to see what numbers an array formula is
calculating. This is the formula I array entered and I know what it does but
in order to work out other formulas it would be nice to see what numbers are
in the array to debug it.
Thanks for your help
Re: array formula questionPosted by Aladin Akyurek on June 09, 2001 11:31 PM
Go to the formula bar, just select the part you're interested in, and hit F9. When you'rr ready, hit ESCAPE, otherwise you loose the formula.
This is a great tip!Posted by IML on June 11, 2001 7:27 AM
Aladin told me about this a few months ago, and it has helped my pathetic array formulas tremendously.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.