Excel General

Hi there,

If I have two columns of numbers in an excel spreadsheet is it possible to put in some formulae or some other function thatlist out the common numbers in both the columns. Basically I need to eliminate the #'s in column A that figure in Column B too.

Thanks for the help.
Cheers,
Srini

Look here:

http://www.cpearson.com/excel/duplic...tingDuplicates

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"sjanaswamy" <sjanaswamy.2cwilh_1156182607.7088@excelforum-nospam.com> wrote in message
news:sjanaswamy.2cwilh_1156182607.7088@excelforum-nospam.com...
|
| Hi there,
|
| If I have two columns of numbers in an excel spreadsheet is it possible
| to put in some formulae or some other function thatlist out the common
| numbers in both the columns. Basically I need to eliminate the #'s in
| column A that figure in Column B too.
|
| Thanks for the help.
| Cheers,
| Srini
|
|
| --
| sjanaswamy
| ------------------------------------------------------------------------
| sjanaswamy's Profile: http://www.excelforum.com/member.php...o&userid=14057
| View this thread: http://www.excelforum.com/showthread...hreadid=573850
|