Spreadsheet: 878455d1725535288-auto-number-generate-with-conditions-srno-help
Sheet: Plate_Data_Entry

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Type | Attribute | Value | Time | Rank
Data Entry Area |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-01-05 00:00:00
 |  |  |  |  |  |  | Calculated Value |  |  |  |  |  |  |  |  | Calculated Value |  |  |  |  | I need  this type of numbering. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Receipt _ Dt | 2024-01-05 00:00:00
Item Type | Item No | Column5 | Column4 | Column3 | Receipt _ Dt | Column1 | [NAME] | Column9 | Column10 | Column11 | Column8 | Column6 | Column2 | Return  _ Dt | Column7 | Return Sr No |  |  |  | Item Type | Item No | Column5 | Column4 | Column3 | Receipt _ Dt | Column1 | [NAME] | Column9 | Column10 | Column11 | Column8 | Column6 | Column2 | Return  _ Dt | Column7 | Return Sr No |  |  |  |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-01-05 00:00:00
111 | A |  |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-09 00:00:00 |  |  |  |  |  | 111 | A |  |  |  | 2024-01-01 00:00:00 |  | 1 |  |  |  |  |  |  | 2024-01-09 00:00:00 |  | 5 |  |  | I need this type of numbering. |  |  |  |  |  |  | 1 | Return  _ Dt | 2024-01-09 00:00:00
111 | B |  |  |  | 2024-01-05 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-10 00:00:00 |  |  |  |  |  | 111 | B |  |  |  | 2024-01-05 00:00:00 |  | 2 |  |  |  |  |  |  | 2024-01-10 00:00:00 |  | 7 |  |  | 1) date will be typed and receipt no (A) & return no. (B) to come automatically through |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-01-09 00:00:00
111 | D |  |  |  | 2024-01-05 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-13 00:00:00 |  |  |  |  |  | 111 | D |  |  |  | 2024-01-05 00:00:00 |  | 2 |  |  |  |  |  |  | 2024-01-13 00:00:00 |  | 12 |  |  | 2)  For same receipt date, same number to come ([NAME]: date: 05/01/24 & 26/01/24 |  |  |  |  |  |  | 1 | Return  _ Dt | 2024-01-10 00:00:00
333 | C |  |  |  | 2024-01-05 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-11 00:00:00 |  |  |  |  |  | 333 | C |  |  |  | 2024-01-05 00:00:00 |  | 3 |  |  |  |  |  |  | 2024-01-11 00:00:00 |  | 8 |  |  | 3)  For same Return date, same number to come ([NAME]: date: 31/01/24 |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-01-10 00:00:00
111 | E |  |  |  | 2024-01-09 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-22 00:00:00 |  |  |  |  |  | 111 | E |  |  |  | 2024-01-09 00:00:00 |  | 4 |  |  |  |  |  |  | 2024-01-22 00:00:00 |  | 13 |  |  | 3) For same date: for receipt & return different no. ([NAME]. date: 09/01/24 & 26/01/24 |  |  |  |  |  |  | 3 | Return  _ Dt | 2024-01-11 00:00:00
111 | F |  |  |  | 2024-01-10 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-12 00:00:00 |  |  |  |  |  | 111 | F |  |  |  | 2024-01-10 00:00:00 |  | 6 |  |  |  |  |  |  | 2024-01-12 00:00:00 |  | 9 |  |  | 4) For receipt date: 09/01/24, receipt no (A) is 3. for return date same date (09/01/24: return no (B) to be 4 (one more that 3) |  |  |  |  |  |  | 1 | Return  _ Dt | 2024-01-12 00:00:00
111 | G |  |  |  | 2024-01-13 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-31 00:00:00 |  |  |  |  |  | 111 | G |  |  |  | 2024-01-13 00:00:00 |  | 10 |  |  |  |  |  |  | 2024-01-31 00:00:00 |  | 20 |  |  | 5) Receipt no. (A) required is maximum of receipt no & return no. for a particular date. ([NAME]. for 10/01/24 receipt no is 5, which is one more that the earlier date i.e. 9/01/24. Also, referrer date: 26/04/24 & 27/01/24 |  |  |  |  |  |  | 1 | Return  _ Dt | 2024-01-13 00:00:00
111 | A |  |  |  | 2024-01-20 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-31 00:00:00 |  |  |  |  |  | 111 | A |  |  |  | 2024-01-20 00:00:00 |  | 11 |  |  |  |  |  |  | 2024-01-31 00:00:00 |  | 20 |  |  | 6) Return no. (B) required is maximum of receipt no & return no. for a particular date. ([NAME]. for 31/01/24 return no is 17, which is one more that the earlier date i.e. 27/01/24 |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-01-13 00:00:00
111 | B |  |  |  | 2024-01-25 00:00:00 |  |  |  |  |  |  |  |  | 2024-08-29 00:00:00 |  |  |  |  |  | 111 | B |  |  |  | 2024-01-25 00:00:00 |  | 14 |  |  |  |  |  |  | 2024-08-29 00:00:00 |  | 17 |  |  |  |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-01-20 00:00:00
111 | C |  |  |  | 2024-01-26 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-26 00:00:00 |  |  |  |  |  | 111 | C |  |  |  | 2024-01-26 00:00:00 |  | 15 |  |  |  |  |  |  | 2024-01-26 00:00:00 |  | 16 |  |  | 7) The above numbering type is shown with same Item Type. |  |  |  |  |  |  | 1 | Return  _ Dt | 2024-01-22 00:00:00
111 | D |  |  |  | 2024-01-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 111 | D |  |  |  | 2024-01-26 00:00:00 |  | 15 |  |  |  |  |  |  |  |  |  |  |  | 8) With the change of item type with receipt & return no will change to next higher number. Refer date: 27/01/24 |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-01-25 00:00:00
111 | E |  |  |  | 2024-01-30 00:00:00 |  |  |  |  |  |  |  |  | 2024-08-01 00:00:00 |  |  |  |  |  | 111 | E |  |  |  | 2024-01-30 00:00:00 |  | 18 |  |  |  |  |  |  | 2024-08-01 00:00:00 |  |  |  |  | 9) Refer date 28/01/24, even though the receipt date is same, but the item no is different, hence receipt no is chnaged |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-01-26 00:00:00
222 | F |  |  |  | 2024-01-30 00:00:00 |  |  |  |  |  |  |  |  | 2024-02-15 00:00:00 |  |  |  |  |  | 222 | F |  |  |  | 2024-01-30 00:00:00 |  | 19 |  |  |  |  |  |  | 2024-02-15 00:00:00 |  | 20 |  |  | 10) with the change of Item type, receipt date & return date, receipt no (A) & return no. ( B) will change to next higher no. available. |  |  |  |  |  |  | 1 | Return  _ Dt | 2024-01-26 00:00:00
111 | G |  |  |  | 2024-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 111 | G |  |  |  | 2024-02-28 00:00:00 |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-01-26 00:00:00
222 | C |  |  |  | 2024-02-28 00:00:00 |  |  |  |  |  |  |  |  | 2024-08-11 00:00:00 |  |  |  |  |  | 222 | C |  |  |  | 2024-02-28 00:00:00 |  | 22 |  |  |  |  |  |  | 2024-08-11 00:00:00 |  | 28 |  |  |  |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-01-27 00:00:00
111 | D |  |  |  | 2024-03-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 111 | D |  |  |  | 2024-03-15 00:00:00 |  | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Receipt _ Dt | 2024-01-27 00:00:00
222 | AA |  |  |  | 2024-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 222 | AA |  |  |  | 2024-03-31 00:00:00 |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-01-28 00:00:00
111 | w |  |  |  | 2024-07-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 111 | w |  |  |  | 2024-07-29 00:00:00 |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Receipt _ Dt | 2024-01-28 00:00:00
333 | w |  |  |  | 2024-07-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 333 | w |  |  |  | 2024-07-31 00:00:00 |  | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Return  _ Dt | 2024-01-31 00:00:00
333 | QQQ |  |  |  | 2024-08-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 333 | QQQ |  |  |  | 2024-08-10 00:00:00 |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Return  _ Dt | 2024-01-31 00:00:00
333 | ww |  |  |  | 2024-08-25 00:00:00 |  |  |  |  |  |  |  |  | 2024-08-16 00:00:00 |  |  |  |  |  | 333 | ww |  |  |  | 2024-08-25 00:00:00 |  | 30 |  |  |  |  |  |  | 2024-08-16 00:00:00 |  | 29 |  |  |  |  |  |  |  |  |  | 2 | Return  _ Dt | 2024-02-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-02-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Receipt _ Dt | 2024-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Receipt _ Dt | 2024-07-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Receipt _ Dt | 2024-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Return  _ Dt | 2024-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Receipt _ Dt | 2024-08-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Return  _ Dt | 2024-08-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Return  _ Dt | 2024-08-16 00:00:00
Data Entry Area |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Receipt _ Dt | 2024-08-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Return  _ Dt | 2024-08-29 00:00:00