hi, i'm self tought in Excel.

I have a row of numbers that are always changing(they're linked to other excel sheets). The numbers are sumtimes negative and sumtimes positive..I'm trying to find out if there's a formula to tell me how many days a number has been negative or positive for??

Many thanks in advance

Paul

Do the numbers change more than once a day? If so, should each change be counted? Are you looking to check the numbers in a specific column or in multiple columns? (Details would help.)

Will the spreadsheet be opened every day in order to take the count or might it be closed for e.g. 3 days, with those 3 days being assumed to remain either positive or negative, and therefore be counted as 3 days at one or the other.

My assumption is that this is going to need a VBA solution and that the date calculations will need to be done based on when the sheet is opened/updated.

The more details you can provide about what you are trying to do would help us design a solution.

Hey thanks for your reply, but i just sorted my problem out on another forum i had posted on earlier. Thanks

So, point us to the thread. I'm interested in seeing the solution.

Thanks.

Ask Your Question

Weekly Poll