I have a spreadsheet with 3 columns. col 1 is the date, col 2 is a value, in col 3 i want the min value of a range of dates based on col 1. i.e. cell A1 = 2/1/10 in A3 i want the min value in col 2 for the last year, since 2/1/09.-- Im trying to find min values of data during a time period. Thanks
Reply from Richard Rost:
Mike, I don't understand the question. Can you give me an example. I don't get what you're trying to find.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
