I had a problem in Excel 2003 , I am having fields of DATE, AND QUANTIY for doing max(B1:B30)OF QUANTITY it is showing result, but i want the result as Max(result) and where(which date) the maximum result in date field which is in (a1:a30). Please give solution.
Any body give proper reply, I will be gratefull to them. -sathyadharani@gmail.com