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:



      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.