>>> "AP" == Andrew Pitonyak 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) an
I think you can do =a1/max($a).
I'm not sure of the format but you can specify shortform for the whole
row.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://w
On Monday, October 02, 2023 09:02 EDT, Uwe Brauer wrote:
So I thought
| Marks | Scaled |
|---+|
| 1 | =A1/max(A1:A7) |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
That gives the correct entry for B1, however if now, drag with the mouse
down that formula I obtain
| Mark
Wade Smart's answer is your solution. The reason is that you will
freeze each component of the address of the reference for the maximum
function. That is, $A freezes the column, $1 freezes the row within the
column. By freezing the max function's reference, you allow the scaled
cell to advan
Try
=A1/MAX($A$1:$A$7)
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Mon, Oct 2, 2023 at 8:13 AM Uwe Brauer wrote:
>
>
> Hi
>
> I have the following simple table
>
> | Marks | Scaled |
> |---+|
> | 1 ||
> | 2 ||
Hi
I have the following simple table
| Marks | Scaled |
|---+|
| 1 ||
| 2 ||
| 3 ||
| 4 ||
| 5 ||
| 6 ||
| 7 ||
In the column scaled I want each value from column Marks, divided by the
maximum of