Hello friend I am working on Excel sheet. I newer to excel .
I want to check what are the elements of a column that exists in another sheet are same elements to new the column. What is Excel formula I can use for this. Or is there any shortcut method for this.
example:
Column A contains 10 rows of element with heading. Now In comes a new Set of NAMES containing 6 rows.
Now i want to know which all of these 6 new rows are present previously in Column A (NAME) and which all are new in the column B (NAMES).
Whichever element is new in column B(NAMES) copy those element into column A(NAME).
Bookmarks