Hopefully you understand on what is desired. 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 The 'AOC' in the serial number indicates that gun was manufactured by Numrich Gun Parts (who acquired the Auto Ordnance manufacturing rights between 19) in the early 1990s. as 1 as my date is older then row 2,3 based to catagory. You never feel their presence but their absence makes your data tasteless. 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. Experts know the importance of serial numbers. Some people are paranoid about posting the serial numbers of their firearms by the way. 1928A1 Savage and Auto Ordnance serial numbers each duplicated the number portion of the serial number with each other with the difference. 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. Shotgun Serial Number Manufactured in FEATURES: 20 Cyl Bore Barrel with Flaming Bomb Mark, 6 Row Heat Shield with Bayonet Lug, Wood Stock with Ordnance. Thompson Serial Numbers - posted in Thompson Submachine Gun.