if catagory input criteria changed Z then it will be 1 only, same way if I change row 3 catagory as Z than keeping same date (1-Jan-20),than Voucher no should be 2 as 1 as my date is older then row 2,3 based to catagory. based on the date sequence, my row “Date” input for particular transaction might change any any given point, suppose row2,3,4/Catagory X has Date as, than my sequence for voucher Sr will be 1,2,3, but if I change row4 Date input to by keeping the same catagory as X than my Voucher should have Sr. I just came accross your site, Indeed its informative, however I am looking for one of the solution/ the way to insert serial no at column based to Random input on multiple criteria at row/column cellsĮxampls, I am trying to maintain a Voucher Series with Alpha numeric as Sr.No.
