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: hyl...@conacher.co.za From: "Hylton Conacher (ZR1HPC)" <hyl...@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:hyl...@conacher.co.za > P.S.: I am subscribed to the LO-Users mailing list > > > -- > 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://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:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- 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://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy