Spreadsheet: 841631d1693820082-create-unique-ref-number-according-to-date-and-item-unique-refs
Sheet: Sheet1

[NAME]. No | Item | Sale Date | Date & Ref. No
1 | Pencils | 2023-09-01 00:00:00 | 1 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
2 | Pens | 2023-09-01 00:00:00 | 2 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
3 | Paper | 2023-09-01 00:00:00 | 3 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
4 | Cards | 2023-09-01 00:00:00 | 4 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
5 | Paper | 2023-09-02 00:00:00 | 5 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
6 | Pencils | 2023-09-02 00:00:00 | 6 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
7 | Cards | 2023-09-03 00:00:00 | 7 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
8 | Cards | 2023-09-03 00:00:00 | 7 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
9 | Cards | 2023-09-03 00:00:00 | 7 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
10 | Pens | 2023-09-04 00:00:00 | 8 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
11 | Pens | 2023-09-04 00:00:00 | 8 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
12 | Cards | 2023-09-04 00:00:00 | 9 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
13 | Cards | 2023-09-04 00:00:00 | 9 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
14 | Pencils | 2023-09-04 00:00:00 | 10 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number
15 | Pens | 2023-09-05 00:00:00 | 11 | < Column D creates a ref number for the item in Column B and checks if the item appears for the same date in Column C - if it does, it gives it the same number. If it does not e.g. same item but different date, it increments to the last number