Find The Value of one column in another colum

Closed

vnitnagpur Posts 1 Registration date Sunday April 19, 2009 Status Member Last seen April 20, 2009 - Apr 20, 2009 at 03:41 AM
VNITNAGOUR - Feb 3, 2011 at 12:12 AM

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).

Find The Value of one column in another colum
Display two columns in data validation list but return only one - Guide
How to delete column in word - Guide
Excel copy column from one sheet to another automatically - Guide
Tweetdeck remove column - Guide
Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum

2 responses

Answer 1 / 2

hggh
Jul 2, 2009 at 08:19 AM

WE ALSO NEED THAT

no
Feb 2, 2011 at 03:23 PM

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

Answer 2 / 2

VNITNAGOUR
Feb 3, 2011 at 12:12 AM

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.

Similar discussions

Auto generate serial number in excel based on Column

Comparing columns and returning value

VBA find column by name and sort

Excel Macro/Code help: Creating sheet for each name in column of another sheet

Converting rows of data in notepad to columns

Similar discussions

Subscribe To Our Newsletter!