formula to subtract

[Kid806022]

Hello,

I'm trying find an easy way to see how many tickets each person sold in a month

sample table below with all details

thank you very much for any help

Kid

[Czeslaw]

Formula

Please Login or Register  to view this content.

[windknife]

D2
=IF(B2=B3,"",C2-INDEX($C$2:C2,MATCH(B2,$B$2:B2,0)))

copied down.

[Czeslaw]

Power Query

Please Login or Register  to view this content.

[josephteh]

Spill formula, D2=IF(B2:B11=B3:B12,"",MAXIFS(C2:C11,B2:B11,B2:B11)-MINIFS(C2:C11,B2:B11,B2:B11))