need more than MAX function

[Jon M]

I have a column of dates. Then 5 more columns with some
true statements. I need to find all of column C that has
True statements and the corrosponding dates and then find
the longest time. ex:
A B C D
11/1 X
11/10 X X
11/12 X X X
11/20 X X

Find the longest time between X's in each column

Can I do this?

 

[Jason Morin]

Put a 1 in E1 if there is an "X" in C1. Then put this in
E2 and fill down:

=IF(C2="X",E1+1)

Now use:

=MAX(E:E)

in a cell to get your answer.

HTH
Jason
Atlanta, GA

 

[EdgeOfCity]

{=MAX(IF(C1:C4,A1:A4))}