| Home |
| Search |
| Today's Posts |
|
#19
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Showing Top 30 with array-formula?
Thanks <vbg.
Ragdyer wrote: 3 years isn't really that long ago.<g As a reminder: http://tinyurl.com/3btqcp -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Dave Peterson" wrote in message ... Ah, but it would be nice if he remembered that stuff! He still uses Edit|Goto|special|current array. Ragdyer wrote: Learned that one from Dave Peterson a long time ago, in a thread where we were discussing this very same subject.. -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Ron Rosenfeld" wrote in message ... On Sat, 30 Jun 2007 14:00:31 -0700, "RagDyeR" wrote: <<<"What I, personally, find aggravating, is that you can't edit the formula without selecting the entire array -- but that may be a plus to some." NOT really accurate! Actually, it's *easier* to revise this type of array *entered* formula. Select *any one* of the cells containing this type of formula. Make your revision, and then simply CSE ... and *every* formula within the *entire* array is revised. To delete the array, select *any one* of the cells in the array, hit <Ctrl < / , then <Delete. The supposed advantage of this type of formula is the conservation of XL's resources, since XL is only storing a single formula. Thanks for those pointers. In particular, I was unaware of the <ctrl</ --ron -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA SHOWING AS #### | Excel Worksheet Functions | |||
| FORMULA NOT SHOWING VALUE | Excel Discussion (Misc queries) | |||
| Formula Showing Zero instead of nothing | Excel Discussion (Misc queries) | |||
| Sum Formula Showing Instead of Value :( | Excel Discussion (Misc queries) | |||
| Showing/ not showing "getting started" when excel starts | Excel Discussion (Misc queries) | |||
Threaded Mode
