Indzara

Fill Missing Values in Excel by Fill-Up Technique?

When you have missing data points in Excel, particularly in a sequence of records, it’s crucial to fill these missing values correctly to maintain the integrity of your data and enable accurate reports and analyses.  

For example, if your source data on orders provides Customer ID and Type as shown below,  

Fill Missing Values by Fill-Up Technique source data

Customer Type is only populated in the rows below. We need to ensure that missing values are populated with the corresponding Type from the row below that is filling-up our missing values.

How to Fill Up? If the corresponding Type value in K7 is missing, return the value from the following row in column M. If it is not missing, return K7 itself.

Fill Missing Values by Fill-Up Technique output

To return the value from the row below, we used Excel’s OFFSET function. The syntax for this is:

Fill Missing Values by Fill-Up Technique  OFFSET function

Check our dedicated video on our YouTube channel for fill-up:

Leave a Reply

Your email address will not be published. Required fields are marked *