comparing common values in 2 seperate columns in excel

[jrwilmott]

I need to compare values in one column with another, and create a seperate column with the common values. I know this is quite easy, but for the life of me I can't recall the syntax of the countif statement. Many thanks

 

[Barry Katcher]

To view the syntax of any function, click on the fx icon on the toolbar and select the function in the dialogue box. A second dialogue box will appear for that specific function, and the syntax is explained at the bottom.

 

[Aladin Akyurek]

See my post in:

http://www.mrexcel.com/board2/viewtopic.php?t=144521

 

[jrwilmott]

thanks

Thanks for your help, much appreciated