2 Replies Latest reply: Mar 27, 2013 3:46 AM by Valeriy Shylin

# Find max(a) of the element with the highest min(b)

Hi guys,

I have a table of time measurements where the dimensions are component and user groups:

Per each of these there is a min_time and max_time values.

I want to display the min and max of these values per each user group (they are 1, 5, 10, 50, 100...).

The proble is that I need MAX(min_time) and MAX(max_time), but the latter should correspond to the component with the max(min_time).

The table below is what I naturally get:

I need the formula to display 17.491 since this is the component with the max(min_time) value.

Any ideas on how to accomplish this?

Valera

• ###### Re: Find max(a) of the element with the highest min(b)

Hi,

Can you post a sample of the data?

By Rebeca

• ###### Re: Find max(a) of the element with the highest min(b)

Well, as it turned out the solution was simpler than the problem.

To find the value of the element with max(a) value it was enough to use the function FirstSortedValue.

The final formula is simple as it is:

=FirstSortedValue (max_time, -min_time)