S
steve_m
I have a large set of data with many entries. I need to find all instances of
any given value in the first column and then return the maximum and minimum
corresponding value in the second column. For example:
110 25.3
111 6.3
113 7.5
110 11.2
112 21.3
113 11.8
114 30.1
110 2.7
In this example I would like to be able to specify a lookup value, 110 for
example and then have a formula/formulae to retrieve the maximum and minimum
value in the second column, 25.3 and 2.7 in this case.
Thanks in advance
any given value in the first column and then return the maximum and minimum
corresponding value in the second column. For example:
110 25.3
111 6.3
113 7.5
110 11.2
112 21.3
113 11.8
114 30.1
110 2.7
In this example I would like to be able to specify a lookup value, 110 for
example and then have a formula/formulae to retrieve the maximum and minimum
value in the second column, 25.3 and 2.7 in this case.
Thanks in advance