Filling in blank cells with information from cells above it

T

tracytracy123

I have a report that I export to Excel that contains financial activity on
loans. Unfortunately, it does not repeat the account number when more than
one transaction has occurred during the period. How can I automatically fill
in the missing account numbers from the cell above so I can run subtotals or
pivot tables? Sometimes there can be several transactions so it might be one
blank cell or several.
 
T

T. Valko

Let's assume your data is in the range A1:A20 with empty cells scattered
within the range.

Select the *entire* range A1:A20
Hit function key F5>Special>Blanks>OK
Type in an equal sign = (do not hit enter!)
Hit the up arrow key
Then hold down the CTRL key then hit ENTER
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem filling in blank cells with data above - 1
Publisher is filling blank lines with data 2
Filling an empty row with the data in row above it 2
Filling in blank cells with cell above 2
counting blank cells in a range 2
blank cells having no value 2
Fill in Blanks with immediately above cell value 4
Blank cells , & cells with 0 in them 1

Top