Hi All
I need to select a min and max value based on a multiple condition. E.g.
Year Level Salary
2010 1 100
2011 2 130
2010 1 90
2011 2 150
2010 1 130
2011 2 200
I need a formula that would return min, max values for 2010 and 2011 separately
Min Max
2010 XX yyy
2011 xx yyy
I have MS Excel 2003.
Many thanks in advance
Niel
I need to select a min and max value based on a multiple condition. E.g.
Year Level Salary
2010 1 100
2011 2 130
2010 1 90
2011 2 150
2010 1 130
2011 2 200
I need a formula that would return min, max values for 2010 and 2011 separately
Min Max
2010 XX yyy
2011 xx yyy
I have MS Excel 2003.
Many thanks in advance
Niel