Excel formula for Longest Losing Runs

[Jonny2621]

Another request for Excel help....

I'm trying to evaluate 10+ spreadsheets and look at longest losing runs. I record win / losses in column D as 1 for a win and 0 for a loss, simple as that.

I'd like to look at the column from row 4 to 1000 and calculate the longest losing run so far, of course ignoring those cells which have nothing in them.

Rocket science pour moi, hopefully simple for others! :thumbs

[mathare]

Just so you know I have seen this and noted it. I'm thinking it over but instinct tells me it's not as easy as it should/could be

[Jonny2621]

cheers Mat, can always depend on you for help. Ive tried the excel for Dummies book and Im getting better at it but Im still a dummy :D