Hi, I'm self tought in Excel
I have a sheet of prices going back 30 days, the prices change everyday, some numbers are negative and some are positive.
I want to know, if a number is negative, how many consecutive days, up until today (current day) has it been negative for?
Thanks for the help
Paul
I have a sheet of prices going back 30 days, the prices change everyday, some numbers are negative and some are positive.
I want to know, if a number is negative, how many consecutive days, up until today (current day) has it been negative for?
Thanks for the help
Paul