[Solved] Keyboard shortcut for array formula entry
-
Hickery Doc
- Posts: 2
- Joined: Mon Nov 07, 2016 10:41 am
[Solved] Keyboard shortcut for array formula entry
II know the formula. {=Average(SMALL(k45:k64;{1;2;3;4;5;6}))} but I can't remember the keys to press to finish off the } part of the formula. I thought it was ctrl + alt + enter but no go so far help Ty
Last edited by MrProgrammer on Thu Jul 25, 2024 5:38 pm, edited 2 times in total.
OpenOffice 4.1.2
Re: combining the average and the small functions in a formula
It is called an array formula and must be entered with Shift+Ctrl+Enter. .
You can search array formulae in the offline HELP - F1 - for more information
You can search array formulae in the offline HELP - F1 - for more information
Slackware 15 (current) 64 bit
Apache OpenOffice 4.1.16
LibreOffice 26.2.3.2; SlackBuild for 26.2.3 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
Apache OpenOffice 4.1.16
LibreOffice 26.2.3.2; SlackBuild for 26.2.3 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
-
Hickery Doc
- Posts: 2
- Joined: Mon Nov 07, 2016 10:41 am
Re: Entering an array formula
Thanks robled, that worked as you said, thought I'd tried all those combo's, but must of missed that one, Ty again. God bless.
OpenOffice 4.1.2