Search : in
By :

Extract identical cells of 2 columns (excel)

Last answer on Apr 13, 2009 4:49:59 pm BST Little bit lost, on Mar 30, 2009 5:05:16 pm BST 
 Report this message to moderators

Hello helpers!,

Got a list of words in column A
Got a list of words in column B
I am looking for a formula that will produce in column C a list of the words that appear on both columns.

Thank you for your help!

Configuration: Mac OS X
Firefox 2.0.0.18

Best answers for « Extract identical cells of 2 columns (excel) » in :
Excel - Extract identical cells of 2 columns Show Excel - Extract identical cells of 2 columns Issue Solution Note Issue Hello, Got a list of words in column A Got a list of words in column B I am looking for a formula that will produce in column C a list of the words that...
Macro to find last blank cell in column (Solved) Show
Repainting a cell using excel VBA Show
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Ask your question Reply

1

mubashir aziz, on Apr 13, 2009 8:17:47 am BST
  • +1

Write it in Column C1 and drag it uptill end ....

=IF(A1=B1,A1,"")

   
Reply to mubashir aziz

2

 Excelguru, on Apr 13, 2009 4:49:59 pm BST
  • +6

Put the following formula in cell C1 and drag down
=IF(COUNTIF($B:$B,A1)>=1,A1,"")

   
Reply to Excelguru
Ask your question Reply
They need your help