Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index

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

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


Then just copy/paste this formula to the cells below.
I hope this helps.

Le dimanche 18 décembre 2022 à 21:18 +0200, Hylton Conacher (ZR1HPC) a
écrit :

I have a RAW Data csv data sheet created which has several of the
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
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
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

Both 'date' fields are formatted as text.
Pointers appreciated.

I have not seen a tutorial online which covers a situation where
is repeating fields on the one hand but a maximum integer on the
column, although I am open to viewing one or possibly even creating a


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.