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

Afternoon Remy,


Thank-you. I had thought of MAX but silly me had not gone further to 
investigate it's descendants. I had just thought that INDEX MATCH was 
THE lookup tool.

The formula has been amended for my sheet names and seems to be working 
well.

Now it seems that the data provided by the cloud provider has errors :(
The next email notifying them of this is on its way.

With the data being over 2.8Million records or 105120 rows and 27 
columns, time to move the data to Base.

Thanks again
Hylton

On 2022/12/19 15:37, Remy Gauthier wrote:
> 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