Filling Blank Cells With the Value in the Cell Above
Today, let’s learn how you can fill blank cells in a table with the values in the cell right above it.
Click here to download the example file, which will help you understand the concept better.
If you see the below screenshot of the example file, you will see that the first column of the table has Parent Product codes, and the last column has the prices of the Child Products. And we need to sum up the prices of all the child products to find the price of the parent product.
This can be achieved in more than one way, but I will be discussing the method I find most easy to use. Below are the steps to achieve our goal.
- Select Column A in the table and press Ctrl + G to open the ‘Go To’ dialogue box. Then press Alt + S to open the ‘Go To Special’ dialogue box. Then press K key to select the ‘Blank’ option. Press OK to close the dialogue box. Now you will see that all the blank cells in the column have been selected.
2. Then make sure that Cell A3 is the active cell and type = and then select cell A2. Then press Ctrl + Enter. Now you will see that all the blank cells in Column A of the table have been filled with the code of the Parent Product. [This is what I want teach in this post]
3. Now all we need to do is to use the SUMIF function to find the total of the prices of all the child products to get the price of the parent product. So type the following in column J4
and then pull it down till Cell J53 to find the prices of all parent products.
That is it!
Hope you found this post interesting.
If you want to get notified by email whenever I post such tutorials, make sure you subscribe to the Mad About Excel newsletter by filling out the below form.
GET MY EXCEL GUIDE FOR FREE
COMPLETE EXCEL FUNCTIONS AND SHORTCUTS GUIDE
Subscribe to our newsletter and get my Complete Excel Functions and Shortcuts Guide for FREE!
Thank you for subscribing.
Something went wrong.
Please share what you felt about this post, or tell me any alternate solution you have, by commenting below.
Thanks for reading. Have a great day. Happy Excelling!