need more than MAX function

  • Thread starter Thread starter Jon M
  • Start date Start date
J

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?
 
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
 
Back
Top