Hey folks,

Product Size Date
A 1 1.1.10
A 1 1.2.10
B 1 1.2.10

My table has several thousand rows. I want to have an overall count based on the following rules:
  • DON'T count when sizes stay the same, but Products Change
  • Count as soon as sizes change; EXCEPT when Product A OR B with size 5 was produced directly before Product C size 4
  • Count when there is a gap of GREATER OR EQUAL 2 days between two entries (e.g. 1.1.10 -> next entry is 4.1.10 --> COUNT! )

Is there a formula or function for that purpose?

Thanks in advance for your help.