Forum Discussion
Solved
Set cell value to the date in cell above if current cell's date is blank
I have dowloaded a csv file from my accounting package of invoices for customers which includes, among other information, the date of the invoice. When opening the csv in Excel, if an invoice has mo...
A possible solution could be Power Query. In the attached file you can enter the data from the csv file into the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
A possible solution could be Power Query. In the attached file you can enter the data from the csv file into the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
OliverScheurich thank you so much! This worked perfectly and I learnt a new Excel skill. 🙂