I have an assignment that I am doing that is rather unique... I have a column with several zeros in it. The zeros represent an event, in other columns I have different values that I need to find the max value that fall inbetween all these zeros. The problem is the cells inbetween zeros vary. I want to say this involves and if statement that references a range between two set values. Ultimately giving me the max value for each set...... I hate life