[Solved] Calc max/lookup formula
[Solved] Calc max/lookup formula
I'm looking for a way to find out the maximum value in a column, ie: MAX(D4:D15). Then what I'm really trying to do is display that value followed by the data from the same row (where the MAX value is located) located in column A , ie: '25 Silver Skipper butterfly'. Thanks in advance.
Last edited by robleyd on Sat May 23, 2020 1:30 am, edited 1 time in total.
Reason: Tagged [Solved]
Reason: Tagged [Solved]
Apache OpenOffice 4.1.7 Windows
Re: Calc max/lookup formula
Try the function VLOOKUP()-
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.