![]() ![]() Click on Visible Cells Only, then click OK.Īlthough you can't see much change on the screen, the selection now skips over the hidden rows. button to open the Go To Special dialogue box. Now use the GoTo command to open the GoTo dialogue box (in Excel 2010, select Find & Select from the Home tab, then select Go To. You will now see only the unmatched rows of column A displayed. We're interested in the middle list (the Match column, or Column B).Ĭlick on the drop-down arrow in cell B1, and click in the check boxes until only the 0 value is selected (checked), then click OK. This will convert each of the headings (cells A1:C1) to a drop-down list. Turn on Filtering (in Excel 2010, select Sort & Filter from the Home tab, and choose Filter). Insert a row above the existing data, to act as a header row, and enter the following values in cells A1:C1 We now have a column of 1s and 0s the 1s represent rows that are duplicated by the other column (C), and the 0s represent rows that are unique. Let's say that your first data set is in A1:A520, and your second data set is in C1:C312. In the new column, use a formula that returns a value of 1 when the value in that row appears somewhere in the other column, and a value of 0 when it doesn't. If you have two data sets, each of which is a single column, and you want to merge them into a single data set that contains all of the values that were in the original two data sets, there are a number of ways you can approach the problem.įor example, if this is a one-time requirement (that is, you just want to do it once, and you don't expect to do it repeatedly), add another column related to each of the original columns. However, while that's what you asked, I doubt it's what you mean. If each of these data sets is actually a single column, and you believe that the longer one contains all the values that are in the shorter one, you can simply copy the longer set over the shorter set.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |