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 Minette,
If the data structured like this
the formula statrting from D2 could be
=IF(ISNUMBER(A2),LOOKUP(9E+99,1/ISTEXT($A$2:$A2),$A$2:$A2),"")
as in attached