Hi,
Attached is a sample. I have column B for different dates and column J for Profit and Loss.
How do I find the maximum loss for a particular month? Column B will increase over time until end of year.
In my sample, I have a main data with 2 tabs, one for Feb and one for Mar. In the month tabs, C1 will select the different months I'm looking at.
Bookmarks