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

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

    Valeriy Shylin

      Hi guys,

       

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

      data structure.PNG

      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:

      wrong_tabl.PNG

       

      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?

       

      Thanks in advance.

      Valera