I have a spreadsheet with customers and invoices. I would like to place zero for the first customer, then 1 for the next customer and back to zero again for the next customer. Is there a way to do this?
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Customer | Amount | Invoice | What I want | ||
2 | 100 | 15 | Inv-150 | 0 | ||
3 | 100 | 15 | Inv-150 | 0 | ||
4 | 200 | 50 | Inv-200 | 1 | ||
5 | 300 | 100 | Inv-250 | 0 | ||
6 | 300 | 100 | Inv-250 | 0 | ||
7 | 400 | 200 | Inv-300 | 1 | ||
8 | 500 | 300 | Inv-400 | 0 | ||
9 | 500 | 300 | Inv-400 | 0 | ||
Sheet1 |