In the formula, A2:A11 is the longer list, and C2:C7 is the shorter list.
Then press Shift + Ctrl + Enter keys to add the first missing data, then drag auto fill handle down to fill all missing data till #N/A error value appears.
And you can remove the #N/A value after all missing values filled.
Find Missing Sequence Number(s) in Excel List
If there are some missing sequence numbers in a list in Excel, you may need to find the missing sequences one by one manually. But if you have Kutools for Excel's Find Missing Sequence Number utility, it can fill the missing sequence number at once and mark the missing rows as you need. Click for 30 days free trial!
Compare two lists and adding missing values with a handy comparing tool
If you have Kutools for Excel installed in Excel, you can use the Select Same & Different Cells utility to quickly find the missing data between two lists, then copy and paste them to the shorter list one.
1. Click Kutools > Select > Select Same & Different Cells. See screenshot:
2. Then in the Select Same & Different Cells dialog, in the Find values in section, choose the longer list, then in the According to section, choose the shorter list, then check Each row and Different Values options.
3. Click Ok > OK, now the missing data in shorter list have been selected, press Ctrl + C to copy them. And then select the cell at the bottom of the shorter list, and press Ctrl + V to paste these missing data.
Compare adjacent cells with Conditional Formatting icon sets in Excel When you compare two columns of data, you want to use the conditional formatting icon sets giving a visual representation of the comparison. For example, if the data in column B is greater than column A, an up arrow icon would show; if column B is less than column A, a down arrow icon would appear; or if column B and A are equal, a right arrow icon would be displayed.
Compare dates if greater than another date in Excel Supposing you have a list of dates, and want to compare these dates with a specified date in order to find out the date which is greater than that specified date in the list, what would you do? In this article, we will show you methods of comparing dates if greater than another date in Excel.
Compare Excel sheets side by side If there are two or more sheets across workbooks needed to compare with each other, it may be annoying for you to switch them one by one for comparing. Here I introduce the tricks on comparing sheets side by side horizontally or vertically.
Compare if multiple cells are equal in Excel As we all know, to compare if two cells are equal, we can use the formula A1=B1. But, if you want to check if multiple cells have the same value, this formula will not work. Today, I will talk about some formulas to compare if multiple cells are equal in Excel.