Re: How to: Find first empty cell in column

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ok, thanks........will this also work on a list that is not in any sort
order or does it have to be sorted?

Don

"Peo Sjoblom" <terre08@xxxxxxxx> wrote in message
news:OzPu4%23dCIHA.5712@xxxxxxxxxxxxxxxxxxxxxxx
It's this part

A1:A10=""

it's what is called an array formula, you can lookup array formula in help

http://www.cpearson.com/excel/ArrayFormulas.aspx


--


Regards,


Peo Sjoblom



"DW" <donwilcox@xxxxxxxxxxxxxx> wrote in message
news:%23cHgt1dCIHA.4476@xxxxxxxxxxxxxxxxxxxxxxx
Thanks everyone....

Now, this might be a dumb question, but why the ctrl+shift + enter combo
to commit the formula?


Don





.

Relevant Pages

  • Re: How to: Find first empty cell in column
    ... it's what is called an array formula, you can lookup array formula in help ... Now, this might be a dumb question, but why the ctrl+shift + enter combo ... to commit the formula? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How to: Find first empty cell in column
    ... it's what is called an array formula, you can lookup array formula in help ... Now, this might be a dumb question, but why the ctrl+shift + enter combo ... to commit the formula? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How to: Find first empty cell in column
    ... Sorting is not necessary ... it's what is called an array formula, you can lookup array formula in ... to commit the formula? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Average a list with high and low ignored
    ... I didn't point out that the AVERAGE/IF formula is an array formula, ... you will have to commit with CTRL-SHIFT-ENTER. ... equation earlier on in the worksheet. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Excel Formula or VBA???
    ... Normally, you type the formula in, and then press the Enter key to commit ... But with an array formula, you type it in, and then commit it by pressing ... When I changed the cell ... I am not a novice using Excel, ...
    (microsoft.public.excel.programming)