Hi, So I have a sales sheet that has monthly sales and total sales column for various products.
What I am looking for is an additional column that shows if the product have not sold in 6 or more months of the year( not consecutive months. )
Irrespective of the number of sales, So I may have product A that in month 5 sold 1000 units. bit nothing in any other month
Then I may have product B that sold 1 unit every month,
So product A I would want a FALSE result and B a true result.
Hope that makes sense.
Bookmarks