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

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History