

 Thread Tools  Search this Thread 
#1
 
 
Find The Value of one column in another column 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). 
#2
 
 
Re: Find The Value of one column in another column You can do it with formula of an array. In first column you can Array enter this formula =IF($A$1<>"",SUMPRODUCT((TEXT($A$2:$A$30,"0")=$A$1),B$2:B$30),"") this formula looks at the name in A1 then finds the same text in column A for each instance it finds it sums the value of the corresponding adjacent cell in column B. When you have Array entered the formula it wil look like this {=IF($A$1<>"",SUMPRODUCT((TEXT($A$2:$A$39,"0")=$A$1),B$2:B$39),"")} NOTE: you cannot copy and paste it as an array formula nor can you just type { before and after it must be done as above, also if you edit the formula you must commit it as an array again. 
#3
 
 
Re: Find The Value of one column in another column I have also same problem. I have about 2000 records in Column 1 (a code consisting of letters and numbers). In Column 2 I have about 1500 records. All of the records in Column 2 are contained in Column 1. However, since about 500 are missing I cannot sort the equal values next to one another  How to make it so that Excel matches the values in Column 2 next to the same values in Column1. Any help would appreciate. 
#4
 
 
Re: Find The Value of one column in another column Use conditional formulas to highlight duplicates... first select the column you want for copy go to conditional formula and use formula given below Formula=COUNTIF($A:$A,$A1)>1 then choose any bright color like RED to make duplicates jump out of assumes that A1 is the first entry to be checked for that 

Tags: column, countif, excel sheet, record, row, sumproduct 
Thread Tools  Search this Thread 

Similar Threads for: "Find The Value of one column in another column"  
Thread  Thread Starter  Forum  Replies  Last Post 
How to find particular column name by using Excel Macro  Eleder  Windows Software  5  05042011 10:49 PM 
How to highlight identical cell value of one column in another column?  D_chapple  Windows Software  3  09122009 01:11 PM 
How to find value in Excel column and then fill down to a particular row  Aienstaien  Software Development  3  01072009 03:04 PM 
mysql update column with another column  Gunter  Software Development  3  23052009 09:44 AM 
Getting the MAX value from a column  rupak  Software Development  4  31012009 11:36 AM 