Forum Discussion
Help with formula to copy headings
I have an export from my accounting software for all my transactions for the year. Each account will have a heading with the unique account number and then all the accounts will then show below. I wa...
Hi Deleted,
I'd recommend using Power Query for automating this. It's built in to Excel 2016 and is a free download for Excel 2013 / 2010.
It's perfect for pulling in and cleaning up exports from accounting systems.
If you can upload a small sample of the export file I can demo a solution for you.
- Or you could go with this formula, assuming your line you want to copy down always has a "-" hyphen in it.
=IF( ISNUMBER( SEARCH("-",A2) ), A2, D1)
So if your formula goes in D2 to start then It looks for the "-" in cell A2 and brings that value back. Otherwise it just brings back the value in the cell above (which will be the account name from the cell above)
So assume