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

At 13:50 15/09/2020 +0200, Hylton Conacher wrote:
I have eight data values on a single row with corresponding dates next to each value in the format below i.e.

A       B       C       D       E       F       G       H
25      01/07   blank   60      09/05   blank   30      26/7

In the 2nd row I would like to show the highest number from the first row as well as the corresponding date value in the cell to the right of that value.

My A2 formula is MAX(A2,D2) = 60

Shouldn't that be =MAX(A1;D1;G1) ?

The issue I am having is to get the corresponding date value from the adjacent column i.e. 09/05 in row B2.

How about
=OFFSET(A1;0;MATCH(A2;A1:G1;0)) ?

Wouldn't you be better off placing your values in three rows of two columns? Then you could use VLOOKUP().

Unfortunately this sort of 'table' VLOOKUP requires is not feasible on my data set.

I don't see why not. It might well be that reorganising your data in some way is the right solution.

I trust this helps.

Brian Barker

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.