Re: [libreoffice-users] LO 6.4.6.2 CALC : Appropriate formula?

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: hylton@conacher.co.za
From: "Hylton Conacher (ZR1HPC)" 
<hylton@conacher.co.za>
Subject: [libreoffice-users] LO 6.4.6.2 CALC : Appropriate 
formula?
To: LibreOffice Users <users@global.libreoffice.org>
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:hylton@conacher.co.za
> P.S.: I am subscribed to the LO-Users mailing list
>
>
> -- 
> 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


+------------------------------------------------------------+
 Michael D. Setzer II - Computer Science Instructor (Retired)     
 mailto:mikes@guam.net                            
 mailto:msetzerii@gmail.com
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




-- 
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