Find The Value of one column in another colum

[Closed]
Report
Posts
1
Registration date
Sunday April 19, 2009
Status
Member
Last seen
April 20, 2009
-
 VNITNAGOUR -
Hello,
I want to check what are the elements from a column that exists in columns(Previously containing rows) and what are the elements that are new to the column. what Excel formula i can use for that. Or is any shortcut method present for this.

Desc:
Column A contains 50 rows of element with heading NAME . 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).

2 replies

WE ALSO NEED THAT
18
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

I would just insert all of the names into one column and delete the duplicates.
Hi,

I resolved this query.

I can use the VLOOKUP or even countif. All these needs to be clubbed with iferror function also.

Let me know, if you need any help with the exact formula.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!