tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I thought this would be simple but it proving to be a challenge please help if you can.
I have a set of data that shows me how many items of a product I sell each month
What I want to identify if if a product was selling well, suddenly stoped selling then began selling again,
So let takr range "BE53:CO53" in in cell Cp35 id like a formula that tells me if sales drop off,
So it starts at BE53, If BE53 is a zero the it finds the first cell with a value greater than zero, If it doesn't find one then it returns "No Drop"
if it find a cell where the value is greater than zero, then it looks to see if any cells after that cell are zero, If it doesn't find one then it returns "No Drop"
If it find another zero then it looks to see if after that zero there is a cell with a value greater than zero, If it doesn't find one then it returns "No Drop"
if it find on it return "Contains Drop"
Please help if you can
Thanks
Tony
I thought this would be simple but it proving to be a challenge please help if you can.
I have a set of data that shows me how many items of a product I sell each month
What I want to identify if if a product was selling well, suddenly stoped selling then began selling again,
So let takr range "BE53:CO53" in in cell Cp35 id like a formula that tells me if sales drop off,
So it starts at BE53, If BE53 is a zero the it finds the first cell with a value greater than zero, If it doesn't find one then it returns "No Drop"
if it find a cell where the value is greater than zero, then it looks to see if any cells after that cell are zero, If it doesn't find one then it returns "No Drop"
If it find another zero then it looks to see if after that zero there is a cell with a value greater than zero, If it doesn't find one then it returns "No Drop"
if it find on it return "Contains Drop"
Please help if you can
Thanks
Tony