First attempt. List removed the formating and stripped the greater than
signs?? So, manual turned off rich text, and see what this attempt looks
like.
If I understand your issue?? Don't know if this will come thru OK.
Put these vaues in row 1 and formula in A2 and B2.
Change Date to my format. Changed values in D1,A1, and G1, and got
the matching date when it was larger.
25
07/01/20
60
05/09/20
30
07/26/20
60
05/09/20
"A2: =IF(AND(A1>D1,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))
"A2: =IF(AND(A1>D1,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: [email protected]
From: "Hylton Conacher (ZR1HPC)"
<[email protected]>
Subject: [libreoffice-users] LO 6.4.6.2 CALC : Appropriate
formula?
To: LibreOffice Users <[email protected]>
Date sent: Tue, 15 Sep 2020 13:50:38 +0200
> HI,
>
> USING
>
> I have eight data values on a single row with corresponding dates next
> to each value in the format below i.e.
>
> ABCDEFGH
> 2501/07blank6009/05blank3026/7
>
> In the 2nd row I would like to show the highest number from the first
> row as well as the corresponding date value in the cell to the right of
> that value.
>
> My A2 formula is MAX(A2,D2) = 60
>
> The issue I am having is to get the corresponding date value from the
> adjacent column i.e. 09/05 in row B2.
>
> The formula I have tried include:
> =VLOOKUP(MAX(A1,D1,G1),B1:H1,FALSE) = #N/A
> =MATCH(INDEX(A2),A1:H1,0) = #N/A
> =HLOOKUP(MAX(A1,D1,G1),A1:H1,1,0) =60 BEING THE SAME
VALUE AS MAX().
>
> I figured that as VLOOKUP looks for values below that HLOOKUP
might be
> better suited. That said I have always battled understanding the
> terminology for the requirements for both vlookup and hlookup, even
> Index and Match needs understanding I don't have.
>
> I read the LO manual online and Google has been some help but seems
to
> always go the VLOOKUP route with all the data under each other.
> Unfortunately this sort of 'table' VLOOKUP requires is not feasible on
> my data set.
>
> I should probably use BASE but have not delved into that especially as
> the data making up these figures is graphed.
>
> Anyone's guidance appreciated.
>
> Regards
> Hylton
> mailto:[email protected]
> P.S.: I am subscribed to the LO-Users mailing list
>
>
> --
> To unsubscribe e-mail to: [email protected]
> 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
+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:[email protected]
mailto:[email protected]
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+
--
To unsubscribe e-mail to: [email protected]
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
