|Subject:||Max and Min formula|
|Posted by:||wx4usa (wx4u…@gmail.com)|
|Date:||2 Jan 2007|
I have sales data on a worksheet. The data entries contain the day in
column A, month in column B, the year in column C and corresponding
sales figures in column D.
THere can be many lines of data for January 2006, not just one per day.
What formula do I use to return the maximum(Max) sales figure for the
month if cell a1 contains the year (2006) and a2 contains the month
Thanks for your help in this!