organising data in a worksheet

Hi all,

Couple of quick questions

Here's what I'm trying to do-

column C contains various positive and negative numbers- I'd like excel to create 2 separate columns-column D containing all of the positive numbers, and column E containing all the negative ones, with it automatically updating whenever I put a new number in column C.

I also want to keep track of how many consecutive positive/negative numbers show up in column C, and have excel to display the maximum consecutive positive/negative numbers in 2 different cells in column F.
Any ideas on how I would do this?

Thanks in advance for any help

Hi Ray,
thanks for the response.

putting the data into Column D and E works great, cheers.

with the 2nd part, putting the formula in will give me the total pos/neg for each column, but won't tell me the max consecutive numbers in the series.

I'd like to be able to have it tell me there was a max of 'x' number of pos or neg numbers consecutively without having to go through the entire list first.
Is there a way to do that?