Ctrl + Shift + Enter is how an array function is entered in to a workbook.
For a really clear and useful explanation of arrays I would suggest the
following web site maintained by Chip Pearson an Excel MS MVP:
http://www.cpearson.com/excel/ArrayFormulas.aspx
I would also recommend that you peruse the Table of Contents on this site as
it has a treasure trove of information and how-to articles.
Hope this helps.
--
Kevin Backmann
"M" wrote:
Also why do you have to use ctrl+shift+enter? I notice that this add {} to
either end but can't find out why??
"Luke M" wrote:
Input this as an array (use Ctrl+Shift+Enter to confirm):
=ADDRESS(MIN(IF(ISTEXT(A2:A4),ROW(A2:A4),FALSE)),C OLUMN(A2),4)
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"M" wrote:
I have a column that contains empty cells and text. I want to return the
reference of the first cell in the column to contain text. For example
A2 = empty cell
A3 = empty cell
A4 = 2L
The formula would return A4
Thanks for your help