[libreoffice-users] INDEX MATCH to find MAX value?

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