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 Add a running total column Insert an autonumber ID column Add suffix/prefix data to. as 1 as my date is older then row 2,3 based to catagory. We are actively working on functionality for Mac Excel (2016). 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. It’s possible to run your life like a pro, keep your stuff secure, find balance, and achieve peace of mind. A free 1-month trial of Microsoft 365 is included with each Microsoft 365 in-app purchase. 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. A qualifying Microsoft 365 subscription is required for Word, Excel, PowerPoint, and Outlook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |