Hi,
I have attached a workbook where I perform a running count with criteria, with 1 for the first count and 0 for the next occurrences.
=IF(COUNTIFS($A$2:$A2;$A2;$B$2:$B2;$B2)>1,0,1)
How can this be done with dynamic formulas giving a spill range? (And without Byrow and Lambda)
Best regards,
Marbleking
Bookmarks