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