Forum Discussion
Solved
Excel Challenge HELP - If you want a challenge with Date, List, Filtering...
I have a list of products sold and the dates they were sold. The first 3 products sold every month are given away for free. So I need in a single cell (if possible), to calculate if the product is on...
=IF(OR(SUMPRODUCT(TEXT($B2,"yyyymm")=TEXT($B$1:$B$51,"yyyymm"))*($B2>$B$2:$B$51))+1)={1,2,3}),0,$C2)$B$2:$B$51 is supposed for the sold date with time.
reference : excel rank by group
