| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array formula lock-up
Excel 2010
Using J. Walkenbach's Excel 2010 Bible, page 396 there is an array formula to return a list of unique items in a range. After entering it I did "something" or made a misstep and now i am hopelessly locked up on that worksheet, with cursor blinking in the formula bar. I went to the formula bar initally and tried Ctrl + Enter in the orginal formula entry cell I3 to try to get the array formula back to a 'plain' formula. By and by I am now locked up in cell I349 and a formula bar with a blinking cursor. I've been able to fight my way out of "You can't change part of an arry" mess before but this one is out of my reach. Thanks for any help. Regards, Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
| formula lock | Excel Discussion (Misc queries) | |||
| Brain lock: using array formula within VBA? | Excel Programming | |||
| Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming | |||
| Lock formula?? | Excel Worksheet Functions | |||
Threaded Mode
