Hi,
I have two columns - a) Column A has Year values, b) Column B has Rate Values as per Years. Like below table data:
Year Rate
2007 10
2007 0
2008 45
2007 54
2007 26
2009 30
2008 4
2007 31
2007 12
2009 44
2007 75
2010 24
I need to calculate >-----> Min() and Max() values from Column B for each Year.
Can anyone please help me to calculate results like below:
Results:
Year Min Max
2007 0 75
2008 4 45
2009 30 44
2010 24 24
Bookmarks