"AP" == Andrew Pitonyak <andrew@pitonyak.org> writes:
Hi
Thanks very much for your answer, it helped me a lot, but let me reply
to your points below.
Uwe Brauer
Your question is a good one.
Either I misunderstand your question or you are doing something I do
not know (so you can teach me something) and I will provide what I
think can be a solution to your problem. Let me start with what I do
not understand.
Where you have B1/max(A2:A7), I actually expected it to be A2:A8, but
You are absolutely right! I was so distracted (and annoyed that out of
the sudden the entries in the max function changed (you explained below
why this is so), that I did not pay attention to the other changes that orrur
So the behavior I wanted to report should be like this
| A | B |
|---+----------------|
| 7 | =A1/max(A1:A7) |
| 2 | =A2/max(A2:A8) |
| 3 | =A3/max(A3:A9) |
| 4 | |
| 5 | |
| 6 | |
| 1 | |
While I wanted
| A | B |
|---+----------------|
| 7 | =A1/max(A1:A7) |
| 2 | =A2/max(A1:A7) |
| 3 | =A3/max(A1:A7) |
| 4 | |
| 5 | |
| 6 | |
| 1 | |
Now you already gave me the answer, using $. I tried this before sending
the question, but not with the correct syntax!
So the correct way of doing this, is:
| A | B |
|---+------------------|
| 7 | =A1/max(A$1:A$7) |
| 2 | =A2/max(A$1:A$7) |
| 3 | =A3/max(A$1:A$7) |
| 4 | |
| 5 | |
| 6 | |
| 1 | |
So I learned something very important thank you again.
Now to the «dragged a formula»
this is basically the same as you do via copying and pasting.
So if I go back to my original question:
| A | B |
|---+----------------|
| 7 | =A1/max(A1:A7) |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 1 | |
So I have just defined a formula in one cell. Instead of copying and
pasting, I take the mouse at the right lower corner
=A1/max(A1:A7)
^(mouse)
And drag it down obtaining
| A | B |
|---+-----------------|
| 7 | =A1/max(A1:A7) |
| 2 | =A2/max(A2:A8) |
| 3 | =A3/max(A3:A9) |
| 4 | =A4/max(A4:A10) |
| 5 | =A5/max(A5:A11) |
| 6 | =A6/max(A6:A12) |
| 1 | =A7/max(A7:A13) |
I have never actually "dragged a formula" so some of what I am about
to say could be wrong. Also, perhaps you can tell me how to "drag with
the mouse". My best guess is that either (1) there is a feature I do
not know or (2) you are doing some kind of selection while entering a
formula (which I know can be done but again, somthing I do not usually
do). I usually drag with a mouse when I am simply selecting cells, but
I am unser how to drag a formula. Then again, I also do not remember
how to do array formulas (I think that is what they call them) even if
I did play with them once some years back.
regards
Uwe Brauer
--
Warning: Content may be disturbing to some audiences
I strongly condemn Putin's war of aggression against the Ukraine.
I support to deliver weapons to Ukraine's military.
I support the NATO membership of the Ukraine.
I support the EU membership of the Ukraine.
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.