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

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