Hello,
I am trying to write formula for the following need:
Column A
Row 1 Test 1
Row 2
Row 3
Row 4 Test 2
Row 5
Row 6 Test 3
I want to write a formula that will automatically copy the previous cell if the current cell is blank.
The Final Result should be:
Row 1 Test 1
Row 2 Test 1
Row 3 Test 1
Row 4 Test 2
Row 5 Test 2
Row 6 Test 3
I have uploaded an excel sheet with 2 tabs "Problem" and " Desired Solution" for better understnding
Bookmarks