Hello,
An answer your V/HLOOKUP question:
HLOOKUP searches for a value on a row (Horizontally) and then goes down
to fetch the corresponding entry on a lower rowVLOOKUP searches for a
value in a column (Vertically) and then goes across to fetch the
corresponding entry on a column to the right
In
At 13:50 15/09/2020 +0200, Hylton Conacher wrote:
I have eight data values on a single row with corresponding dates
next to each value in the format below i.e.
A B C D E F G H
25 01/07 blank 60 09/05 blank 30 26/7
In the 2nd row
,A1>G1),A1,IF(AND(D1>A1,D1>G1),D1,G1))
"B2: =IF(AND(A1>D1,A1>G1),B1,IF(AND(D1>A1,D1>G1),E1,H1))
On 15 Sep 2020 at 13:50, Hylton Conacher (ZR1HPC) wrote:
Send reply to: hyl...@conacher.co.za
From: "Hylton Conacher (ZR1HPC)"
Subject: [libreoffice-users] LO 6.4.6.2 CALC :
;Hylton Conacher (ZR1HPC)hyl...@conacher.co.za
Subject:;[libreoffice-users] LO 6.4.6.2 CALC : Appropriate
formula?
To:;=LibreOffice Usersusers@global.libreoffice.orgDate sent:60;Tue, 15 Sep 2020
13:50:38 +0200
HI,
USING
I have eight data values on a single row with corresponding dates next
HI,
USING
I have eight data values on a single row with corresponding dates next
to each value in the format below i.e.
A B C D E F G H
25 01/07 blank 60 09/05 blank 30 26/7
In the 2nd row I would like to show the highest