Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks in advance.
Valera
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)
Hi,
Can you post a sample of the data?
By Rebeca
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)