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
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,"=")
Then
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