I'm not even sure what formula I could use or if it's even possible so I wasn't sure what subject to use, but I'm running a general ledger detail report and dumping it into excel. in column A it will have the account number followed by a various number of rows showing each transaction for the month in that account number. what I'm doing is inserting a new column so the account number will be on the left of the data. I'm currently going through the entire spreadsheet and copying/pasting each new account number next to the transactions associated with it. is there s a formula I could use that I just copy down the new column A showing each account number? the account numbers are formatted as xxxxx-xx-xx and the new account numbers will be listed on various rows. it just depends how many transactions before the next account number appears.
so currently column B contains account numbers, a number 13 for period 13 and blanks. if I could just have column A use the most recent account number in column B
so currently column B contains account numbers, a number 13 for period 13 and blanks. if I could just have column A use the most recent account number in column B