I have a range of data. In column A is Dates, in column B is amounts. I want
to find the maximum amount in each day in another column for calculating
interest. Can anyone provide me a function for the same.

Thanks in advance