I am looking for a way to carry out a similar function to the AVERAGEIFS function but with differences.
Say that column A has a list of years (of which there are several entries for each year) and column B has a list of values. Is there a way of getting excel to give the difference between the maximum and minimum values in column B for a specific year?
Thanks in advance for any help.
Say that column A has a list of years (of which there are several entries for each year) and column B has a list of values. Is there a way of getting excel to give the difference between the maximum and minimum values in column B for a specific year?
Thanks in advance for any help.