Greetings, If you are looking for the maximum value, would the MAXIFS() function work for you? If you are trying to populate the data in your secondary sheet, with date values in column A, the formula to use in column B2 of the secondary sheet would be:
=MAXIFS(Sheet1.M:M,Sheet1.C:C,"="&A2) Then just copy/paste this formula to the cells below. I hope this helps. Rémy. Le dimanche 18 décembre 2022 à 21:18 +0200, Hylton Conacher (ZR1HPC) a écrit : > Hi, > > I have a RAW Data csv data sheet created which has several of the > same > date entries in column A and an increasing numerical value in another > column i.e.: > C M > 2022-01-01 0 > 2022-01-01 0 > 2022-01-01 0.1 > 2022-01-01 0.0 > 2022-01-02 0.0 > 2022-01-02 0.0 > 2022-01-03 0.5 > 2022-01-03 0.7 > > A secondary sheet has just a single date value and the maximum number > of > the other column i.e.: > 2022-01-01 0.1 > 2022-01-02 0.0 > 2022-01-03 0.7 > . > . > > What I am needing help with, despite viewing multiple Index/Match > online > videos is a method to return the MAX value per date when there are > multiple instances of the search criteria result in 'M' still being > 0. > > Both 'date' fields are formatted as text. > Pointers appreciated. > > I have not seen a tutorial online which covers a situation where > there > is repeating fields on the one hand but a maximum integer on the > other > column, although I am open to viewing one or possibly even creating a > tutorial. > > Regards > Hylton > -- 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
