Spreadsheet: 879100d1726563348-auto-number-generate-with-conditions-tps_srno_getdata1709-tpsdas-
Sheet: DEntry

Data Entry Area
 |  |  |  |  |  |  |  |  |  | Calculated Value |  |  |  |  |  |  |  |  | Calculated Value |  |  | General logic for [NAME]:
Deno | Colour | Column12 | Column13 | Column14 | Column5 | Column4 | Column3 | [NAME] | Column1 | [NAME] | Column9 | Column10 | Column11 | Column8 | Column6 | Column2 | Return Dt | Column7 | Return SrNo |  | Actual [NAME] | same receipt date (I) & same deno (A) : [NAME] should be same ( refer: K6, K7 and also K9, K10)
111 | A |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  | ok | same receipt date (I) &  Different deno (A) & : [NAME] should be different - next higher no. ( refer: K8 and K11)
111 | D |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  | ok | Accordingly, [NAME] should be next higher number of the series i.e 9. Since [NAME] date is changed. (  Presently showing 1 same as A6/A7)
222 | C |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00 |  |  |  | ok | Accordingly, K13 should be next higher number of the series i.e 10. Since [NAME] date is same but the Deno (A) has been changed. ( Presently showing 3 same as A8)
444 | C |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  | ok
444 | D |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  | ok | General logic for [NAME]:
555 | A |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-02 00:00:00 |  |  |  | ok | same Return date (R) & same deno (A) : [NAME] should be same ( refer: T6, T7 and also T9, T10)
111 | A |  |  |  |  |  |  | 2024-01-04 00:00:00 |  |  |  |  |  |  |  |  | 2024-01-05 00:00:00 |  |  |  | 9 | same Return date (R) &  Different deno (A) & : Return SrNo should be different - next higher no. ( refer: T8 and T11)
222 | D |  |  |  |  |  |  | 2024-01-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note : in [NAME] tbl_Data the rank ( ) is coming correctly by the same needs to be reflected in DEntry sheet
 |  |  |  |  |  |  |  |  |  | This is Not OK |  |  |  |  |  |  |  |  | This is OK |  |  | A6, A7 is having same deno (111) & Same Recept Dt ( I :  01/01/24) hence Same recipt SrNo - Correct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A8 is having  different  deno (222) but same [NAME] ( I :  01/01/24) hence  [NAME] is changed to next higher no - Correct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A6, A7 is having same deno (111) & Same Return Dt ( I :  01/01/24) hence [NAME]  is changed to next higher no - Correct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A9, A10 is having  different  deno (444) &  different  [NAME] ( I :  02/01/24) [NAME] is changed to next higher no - Correct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A11 is having  different  deno (555) &  same  [NAME] ( I :  02/01/24) hence, [NAME] is changed to next higher no - Correct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | different [NAME] ( I :  04/01/24) & A12 is having  different  deno (111 - even though repetation of A6/A7 ) &  hence, [NAME] is required to be changed to next higher no - Need Correction
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Same Recept Dt ( I :  04/01/24) & A12 is having  different  deno (222 - even though repetation of A9 ) &  hence, [NAME] is required to be changed to next higher no - Need Correction
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for T9, T10 : return SrNo is same ( 6) . It is correct since, same deno (A) and same return dt ( 02/01/24)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for T11 : return SrNo is different (8) . It is correct since, deno is different even though same return dt ( 02/01/24)