Thank you for the attachment.
jmsld_ wrote:I'm trying to display an adjacent cell content based on the min or max value in a column.
All of your formulas in the attachment fail with Err:508 in OpenOffice because you have used comma as an operand separator instead of semicolon. After fixing those problems:
• A18 returns $B$11, the
address of the cell with longest road length
• A19 fails with Err:502 because you ask for column 2, but specify only one column, B1:B15, in the second operand
• A20 fails with #N/A because you search for the longest distance, a number, in the list of roads, which are text.
Consider that the designation "longest road" might not be unique. Suppose the lengths are: 5, 1, 2, 5, 3, 5.
• To find the name of the
first road with the longest length, you want
=INDEX(A1:A15;MATCH(MAX(B1:B15);B1:B15;0)).
• If you want a list of
all the roads which are that length see
[Tutorial] Sorting and Filtering data with formulas.
[Tutorial] VLOOKUP questions and answers, Q9/A9 and Q24/A24
[Tutorial] Ten concepts that every Calc user should know
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
