Finding Trend using Sales rank

Hi All,

Hope you are doing well!..I have few items and their sales ranks for 5 days ...I am trying to predict whether the item is growing in terms of sales

-Increasing Trend - This is determined if there is a continuous increase in sales rank for 3 of the five days successively

-Declining Trend -This is determined if there is a continuous decrease in sales rank for 3 of the five days successively

Stable Trend -This is determined if the trend is stable in sales rank for 3 of the five days successively


Please find attached the sheet for your reference..

Thanks,
Arun

Thanks Bo_Ry..This Works...Really appreciate your response..