If you have Classic Menu for Office, you can find out the Text to Columns command with the same way that you did in Microsoft Excel 2003/XP(2002)/2000: Click the Data drop down menu under Menus tab Then you will view the Text to Columns item. Hopefully you understand on what is desired. Find out Text to Columns at ease if you have Classic Menu for Office. 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.
0 Comments
Leave a Reply. |