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 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. Now the selected column should reflect this new width. In this example, weve selected a column width of 18. When the Column Width window appears, select the new width value for the column and click on the OK button. 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. Right-click and select 'Column Width' from the popup menu.
0 Comments
Leave a Reply. |