![]() In the screenshot above, cell D5 displays the “Moon Barrientos,” which means that name was found on both List A and B. ![]() Select cell D5 down to the end of the lists and press Ctrl+D to copy the formula and conditional formatting down.Ĭopy the formula down to the end of the lists.Ī name in List C means the corresponding name from List A was also found within List B.In the Equal To dialog box, type 0 and click OK.Select cell D5 and navigate to Home → Conditional Formatting → Highlight Cell Rules → Equal To….In cell D5 enter the formula: =IF(COUNTIF(B:B,A5),A5,0) and press Enter.Create a third column in column D called List C (leave column C blank for easier readability).Arrange the lists in two columns with List A in column A and List B in column B. ![]() After a few weeks you decide to compare both lists to make sure everyone on your friend’s list (List B) is also on your list (List A). You and a friend are throwing an epic party and have each maintained separate guest lists to track who’s coming. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |